Error Executing Database Query.
|
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax near ';'.
|
| |
The error occurred in C:\Websites\mdnightlife.com\htdocs\Power_Plant_Live_Baltimore.cfm: line 1
|
1 : <CFQUERY name="GetRecords" datasource="EVENTSMNL">
2 : SELECT * FROM EVENTSMNL WHERE EVENTCITY LIKE '%Baltimore%' and (eventdate > getdate()
3 : or (datepart(yyyy,eventdate) = datepart(yyyy,getdate())
|
|
| SQL |
SELECT * FROM EVENTSMNL WHERE EVENTCITY LIKE '%Baltimore%' and (eventdate > getdate()
or (datepart(yyyy,eventdate) = datepart(yyyy,getdate())
and datepart(dd,eventdate ) = datepart(dd,getdate())
and datepart(mm,eventdate) = datepart(mm,getdate()) ) ) ORDER BY EVENTDATE, EVENTTYPE2 |
| DATASOURCE |
EVENTSMNL |
| VENDORERRORCODE |
170 |
| SQLSTATE |
HY000 |
|
|
Resources:
|
| Browser |
CCBot/1.0 (+http://www.commoncrawl.org/bot.html) |
| Remote Address |
38.103.63.16 |
| Referrer |
|
| Date/Time |
13-May-08 01:26 AM |
|