als jij denkt dat dat helpt, hierbij de code :
de CFINDEX :
<CFINDEX
ACTION="REFRESH"
TYPE="CUSTOM"
COLLECTION="OVERMED"
KEY="SUB_ID"
TITLE="Over Medinet"
BODY="SUB_LINKTITLE, SUB_TITLE, SUB_DESC, SUBSUB_LINKTITLE, SUBSUB_TITLE, SUBSUB_DESC, ATTACHMENT_LINKTITLE, ATTACHMENT_DESC"
CUSTOM1="SUB_LINKTITLE"
QUERY="OVERMED">
de query=
<CFQUERY NAME="OVERMED" DATASOURCE="#DATSRC#">
SELECT *
FROM (MED_ATTACHMENT
LEFT JOINMED_SUB
ONMED_ATTACHMENT.ATTACHMENT_X_RECORD_ID =
MED_SUB.SUB_ID)
LEFT JOINMED_SUBSUB
ONMED_SUB.SUB_ID =
MED_SUBSUB.SUBSUB_X_SUB_ID
LEFT JOIN MED_ATTACHMENT
ON MED_SUBSUB.SUBSUB_ID = MED_ATTACHMENT.ATTACHMENT_X_RECORD_ID
WHERE MED_SUB.SUB_MENU_ITEM = '6'
</CFQUERY>
en de foutmelding :
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'MED_SUB.SUB_ID = MED_SUBSUB.SUBSUB_X_SUB_ID LEFT JOIN MED_ATTACHMENT ON MED_SUBSUB.SUBSUB_ID = MED_ATTACHMENT.ATTACHMENT_X_RECORD_ID'.
SQL = "SELECT * FROM (MED_ATTACHMENT LEFT JOIN MED_SUB ON MED_ATTACHMENT.ATTACHMENT_X_RECORD_ID = MED_SUB.SUB_ID) LEFT JOIN MED_SUBSUB ON MED_SUB.SUB_ID = MED_SUBSUB.SUBSUB_X_SUB_ID LEFT JOIN MED_ATTACHMENT ON MED_SUBSUB.SUBSUB_ID = MED_ATTACHMENT.ATTACHMENT_X_RECORD_ID WHERE MED_SUB.SUB_MENU_ITEM = '6'"
Data Source = "MEDINET"
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (10:1) to (10:46)
als ik uit de query de laatste LEFT JOIN verwijder, is er geen probleem. Maar met deze 3 LEFT JOIN, krijg ik telkens de error
