Error Diagnostic InformationODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 4: Incorrect syntax near ')'. SQL = "SELECT TBL_CX_CREATIVES.RedirectURL,TBL_CX_CREATIVES.CPCRATEPAID as cpcadrate, TBL_CX_CREATIVES.CPCRATEPAID * cpcratepaid as PUBPERCENT FROM TBL_CX_CREATIVES WITH (NOLOCK) WHERE (((TBL_CX_CREATIVES.pk_creativeid)=?) AND ((TBL_CX_CREATIVES.fk_siteid)=))" Query Parameter Value(s) - Parameter #1 = 70 Data Source = "ADWONDER" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1238:2) to (1238:165) in the template file D:\INETPUB\WWWROOT\GODSPY\REVORG\ADWONDER\SERVE\ADWONDER.CFM. Date/Time: 03/27/08 14:38:18 |