[Macromedia][SQLServer JDBC Driver]Syntax error at token 0, line 0 offset 0
Posted May 18, 2006 at 7:30 AM
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.
Post Comment | Ask Ben | Permalink | Other Searches | Print Page
Newer Post
Sticky Notes For Important Postings
Older Post
The Processing Instruction Target Matching "[xX][mM][lL]" is Not Allowed
Reader Comments
I saw this error about four time (with out any cfif tags in my SQL statement) and decided to Google it. Thanks!
Thanks for the help. I get this at times and fix it by looking extensively at the code, but this makes sense now.
Great, Thanks Ben!
This just saved me alot of time. I copied and pasted a query outside the closing cfquery tag. Duh.
@Walt,
Gald to help. This is such an odd error and totally not obvious when you're looking at the ColdFusion code.
Thanks Ben. I thought sure you were wrong on this error, but it turned out to be a missing CFIF.
Was beating my head against the wall until I realized I had removed my SQL statements but not the cfquery tags themselves, and inserted a bunch of code between. Would still be looking for it if not for this post. Many thanks! :-)
@JEBster,
Hey man, glad to help :)
Really this saved me some hair, Thanks man
