|
|
i have used the attached code but am getting the following error.
Any sugestions on the what the problem is
[b]ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression 'cw.caseworkerid = cd.caseworkerid INNER JOIN broker ON
cd.brokerid = b.brokerid'.
SQL = "SELECT cd.client_id, cd.solicitorid, cd.transaction, cd.clientsurname,
cd.clientfirstname, cd.clientaddress1, cw.caseworkername, b.brokername FROM
clientdetails cd INNER JOIN caseworker ON cw.caseworkerid = cd.caseworkerid
INNER JOIN broker ON cd.brokerid = b.brokerid WHERE cd.solicitorid=1 ORDER BY
cd.clientsurname"
[/b]
<cfquery name="searchall" datasource="webconveyancer" dbtype="ODBC">
SELECT cd.client_id,
cd.solicitorid,
cd.transaction,
cd.clientsurname,
cd.clientfirstname,
cd.clientaddress1,
cw.caseworkername,
b.brokername
FROM clientdetails cd
INNER JOIN caseworker ON cw.caseworkerid = cd.caseworkerid
INNER JOIN broker ON cd.brokerid = b.brokerid
WHERE cd.solicitorid=#solicitorid#
ORDER BY cd.clientsurname
</cfquery>
|
|