[Macromedia][SQLServer JDBC Driver]Syntax error at token 0, line 0 offset 0

Posted May 18, 2006 at 7:30 AM

Tags: ColdFusion, SQL

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



Learning ColdFusion 9 - ColdFusion 9 tutorials, samples, examples, demos

Reader Comments

L Baker
Feb 3, 2007 at 8:54 PM // reply »
1 Comments
1 Points

I saw this error about four time (with out any cfif tags in my SQL statement) and decided to Google it. Thanks!


T
Aug 9, 2007 at 4:49 PM // reply »
1 Comments
1 Points

Thanks for the help. I get this at times and fix it by looking extensively at the code, but this makes sense now.


Andrew Maurer
Oct 23, 2008 at 3:22 PM // reply »
1 Comments
1 Points

Great, Thanks Ben!


walt
Nov 5, 2008 at 10:55 AM // reply »
1 Comments
1 Points

This just saved me alot of time. I copied and pasted a query outside the closing cfquery tag. Duh.


Ben Nadel
Nov 5, 2008 at 10:58 AM // reply »
6,516 Comments
25,763 Points

@Walt,

Gald to help. This is such an odd error and totally not obvious when you're looking at the ColdFusion code.


Another Ben
Mar 9, 2009 at 4:15 PM // reply »
2 Comments
21 Points

Thanks Ben. I thought sure you were wrong on this error, but it turned out to be a missing CFIF.


JEBster
May 15, 2009 at 12:47 PM // reply »
1 Comments
12 Points

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! :-)


Ben Nadel
May 19, 2009 at 9:27 AM // reply »
6,516 Comments
25,763 Points

@JEBster,

Hey man, glad to help :)


Riyaz
Sep 14, 2009 at 9:09 AM // reply »
1 Comments
12 Points

Really this saved me some hair, Thanks man


Post Comment  |  Ask Ben

Recent Blog Comments
<scriptalert('just a test buddy :)')script
Nov 21, 2009 at 12:41 AM
Ask Ben: Building An AJAX, jQuery, And ColdFusion Powered Application
13311qseqweqwe ... read »
Budd Wright
Nov 20, 2009 at 11:32 PM
Five Months Without Hungarian Notation And I'm Loving It
I've used headless camel case for years for not only ColdFusion variables, but also SQL tables and fields... pretty much everything involving code. I also subscribe to the "don't abbreviate and clea ... read »
Ben Nadel
Nov 20, 2009 at 11:00 PM
Five Months Without Hungarian Notation And I'm Loving It
@Marcel, Yeah, I always err on the side of longer but more readable variable names. As for the camel casing of CF methods and the headless camel casing of custom items, I get around this by always ... read »
Marcel
Nov 20, 2009 at 10:56 PM
Five Months Without Hungarian Notation And I'm Loving It
I use the following and love it: my.namespace.MyComponents.functionMethodsOrUDF() CONSTANT_VALUES_OR_PROPERTIES One thing I always try is to CamelCaseBuiltInColdFusionFunctions() so others can tell ... read »
Darren
Nov 20, 2009 at 5:38 PM
Learning ColdFusion 8: CFImage Part I - Reading And Writing Images
Hi Ben, Great article. I've been looking around to see if ColdFusion image engine can programatically create the following "wrap around" effect: http://www.creativepro.com/article/photoshop-s-she ... read »
Todd Rafferty
Nov 20, 2009 at 5:35 PM
Maintaining ColdFusion Sessions Across SMS Text Message Requests Without Cookies
@Dave: I talked to Gert he suggested: <cfhttp method="get" url="http://{some cf website}" result="stuff" addtoken="yes" /> Note the addition of cfhttp attribute addtoken. That should persist y ... read »
Ben Nadel
Nov 20, 2009 at 5:23 PM
Maintaining ColdFusion Sessions Across SMS Text Message Requests Without Cookies
@Todd, Ahh, gotcha, yeah that makes sense. ... read »
Todd Rafferty
Nov 20, 2009 at 5:17 PM
Maintaining ColdFusion Sessions Across SMS Text Message Requests Without Cookies
Ben, sorry if I didn't make this clear. You can make it work like that if you want, just put <cfset session.foo = 1> (and <cfset application.foo = 1>) in your OnRequestStart() and it reve ... read »