Error Diagnostic InformationODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'WA' does not match with a table name or alias name used in the query. SQL = "SELECT * FROM Hotellist WHERE HOTELID = WA.htm" Data Source = "RATESWCTRAVEL" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (7:2) to (7:54) in the template file F:\INETSRV\WWWROOT\WEBHOSTS\ARRIVALZ\WEBFILES\HOTELPROFILE.CFM. Date/Time: 07/04/09 20:19:00 |
Please inform the site administrator that this error has occurred (be sure to include the contents of this page in your message to the administrator).