 |
 |
Profile  |
Services |
Clients |
Contact |
News |
 |
|
|
|
|
||||||||
|
|||||||||
| |||||||||
Error Diagnostic InformationODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'index'. SQL = "select * from newsArticles where active = 1 AND deleted = 0 AND articleID = index.cfm AND (startDate <= {ts '2012-05-20 00:00:00'} OR startDate IS NULL) AND (endDate >= {ts '2012-05-31 23:59:59'} OR endDate IS NULL)" Data Source = "EXCEDIORWEBSITE" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (10:1) to (10:58) in the template file E:\VIRTUALHOSTS\EXCEDIOR.COM\WWW\QUERIES\QRY_GETNEWSARTICLE.CFM. Date/Time: 05/20/12 04:42:50 |