Online Database

[travismp]

I am running an Access Database online. Working with a ASP page. Microsoft troubleshooting is pointing to an error with a query and the way I am writting it. Any help...

Microsoft Error: "Syntax error (missing operator)"
(Attached Image for exact error) ...

Here is the way I wrote my scripting out in my asp page...

fp_sQry="SELECT * FROM ""SUBFORM"" WHERE (COMMODITY CODE = '::COMMODITY CODE::')"

Thanks all who look and help.

 

[charityg]

Try
fp_sQry="SELECT * FROM SUBFORM WHERE (COMMODITY CODE = '" & ::COMMODITY CODE:: & "')"

By the way is subform the name of a table or query?
If not this won't work.
If so, you probably shouldn't name a table or query "subform"

 

[travismp]

Thanks for the quick reply and answer. It is the name of a query. I did not make the database, I am trying to clean it up for someone else. thanks

Someone else gave me this example:

fp_sQry="SELECT * FROM SUBFORM WHERE ([COMMODITY CODE] = '::COMMODITY CODE::')"


And it worked perfect. Thanks for your help.