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="get_branch" datasource="#datasource#" username="XXXX" password="XXXX">
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,
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="get_branch" datasource="#datasource#" username="XXXX" password="XXXX">
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,