Syntax error (missing operator) in query expression

[crystalfish0318]

Hi,
I have received the following error:
ODBC Error Code = 37000 (Syntax error or access violation)

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression 'topic='.

The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (58:1) to (58:66).

i believe the error is here:

<cfquery name="get_cust_topCode" datasource="dstbc" dbtype="ODBC">
SELECT *
FROM a2tblTopic
WHERE topicID=#form.topic#

i have no idea what's wrong with my topicID?

i have tried some serveral changes, such as (), '', "", and single perserve
quote,
but still doens't work.
i have tried to just use topicID=#topic#
or topicID=(#form.topic#).........

any ideas?

[Dan Bracuk]

Your error message suggests that form.topic is an empty string.

[paross1]

The error message seems indicate that the problem is with the expression
'topic=' yet your query lists the field as topicID, so did you cut/paste the
actual query that is causing the error into your message? I'd go back to your
page and make sure that you actually have the field name topicID in your query.

Phil