Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CF: ODBC Error Code = 37000 (Syntax error or access vio

Status
Not open for further replies.

bde1145

Technical User
Mar 11, 2003
1
US
Hello All,
This is my first post.

I'm getting the following error on a page that has worked previously and has not been changed:

Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)


[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.



The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (22:1) to (22:101).


Date/Time: 03/11/03 08:43:25
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.0.3705)
Remote Address: 208.168.194.32
HTTP Referer:

This is the code being referrenced in the error:

<!--- find name of branch --->
<CFQUERY NAME=&quot;get_branch&quot; datasource=&quot;#datasource#&quot; username=&quot;XXXX&quot; password=&quot;XXXX&quot;>
Select * from BRANCH where ID=#session.BRANCH#
</CFQUERY>



This code has not been changed and was working a few days ago. I did not design this app and am a CF newbie. Any thoughts would be much appreciated.

Thanks,
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top