Error Diagnostic InformationODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '='. SQL = "select max(arch_datetime) as lastpub from tpublish where arch_pagepath='treasury/hotel-motel' and arch_siteid='MuniTreasury' and arch_oid=" Data Source = "SM_ARCHIVER" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (56:1) to (56:52) in the template file Z:\MOA\PUB\WWW\TREASURY\..\CONFIG21TREASURY.CFM. Date/Time: 11/20/08 07:20:49 |