Error Diagnostic InformationODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near '='. SQL = "SELECT * FROM Job_Titles WHERE Job_Title_ID =" Data Source = "PRMACCESS" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1081:3) to (1081:135) in the template file D:\INETPUB\CAREGATEWAY\PORTAL\WEBSITE_MANAGER\CUSTOMER_WEBPAGE.CFM. Date/Time: 09/03/10 15:41:58 |