I spend a good amount of time helping other people debug their code and I run into this error plenty of times: [Macromedia][SQLServer JDBC Driver]Syntax error at token 0, line 0 offset 0. The first time I ran into it, I was helping a co-worker with a Query statement that had many CFIF statements. Having never seen it before, it took some time to figure out. Now, it's just obvious. No SQL is being passed to the database. He had so many CFIF statements with crazy logic, that none of them were TRUE and no SQL code was being evaluated.
If you ever get this, take out some logic, you probably don't need it.
Comments (2) | Post Comment | Ask Ben | Permalink | Other Searches | Print Page
Sticky Notes For Important Postings
The Processing Instruction Target Matching "[xX][mM][lL]" is Not Allowed
I saw this error about four time (with out any cfif tags in my SQL statement) and decided to Google it. Thanks!
Posted by L Baker on Feb 3, 2007 at 8:54 PM
Thanks for the help. I get this at times and fix it by looking extensively at the code, but this makes sense now.
Posted by T on Aug 9, 2007 at 4:49 PM