RE: ODBC Error Code = 37000 UGH!!!!!!!!!!!!!
what is the code for the query? I'd guess that it's either a Where problem or a variable reference problem. Hatton -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 10:35 PM To: CF-Talk Subject: ODBC Error Code = 37000 UGH! I have CF 4.5.1 SP2, MDAC 2.6, SQL SP3. Does this whenever I set a client variable. Anyone seen this before? Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '55'. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Error Code = 37000 UGH!!!!!!!!!!!!!
No query at all, it's a client variable going to a database. -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 10:56 PM To: CF-Talk Subject: RE: ODBC Error Code = 37000 UGH! what is the code for the query? I'd guess that it's either a Where problem or a variable reference problem. Hatton -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 10:35 PM To: CF-Talk Subject: ODBC Error Code = 37000 UGH! I have CF 4.5.1 SP2, MDAC 2.6, SQL SP3. Does this whenever I set a client variable. Anyone seen this before? Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '55'. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Error Code = 37000 UGH!!!!!!!!!!!!!
okay, there's got to be some SQL going from CF to the database driver... either an insert into or an update. Check to make sure that the variable you're updating in the database is the propper type for what CF is trying to put there. HTH Hatton -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 10:51 PM To: CF-Talk Subject: RE: ODBC Error Code = 37000 UGH! No query at all, it's a client variable going to a database. -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 10:56 PM To: CF-Talk Subject: RE: ODBC Error Code = 37000 UGH! what is the code for the query? I'd guess that it's either a Where problem or a variable reference problem. Hatton -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 10:35 PM To: CF-Talk Subject: ODBC Error Code = 37000 UGH! I have CF 4.5.1 SP2, MDAC 2.6, SQL SP3. Does this whenever I set a client variable. Anyone seen this before? Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '55'. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists