Error Executing Database Query.
|
|
[Macromedia][SequeLink JDBC Driver][ODBC Socket][MySQL][ODBC 3.51 Driver][mysqld-4.1.22-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND DateFlight <= {ts '2008-05-09 17:56:23'} AND (DateKill >= {ts '2008-05-09 17' at line 1
|
| |
The error occurred in C:\www\goblueraiders.com\section.cfm: line 32
|
30 : WHERE templateid = #TemplateID#
31 : AND DateFlight <= #CreateODBCDateTime(cNow())#
32 : AND (DateKill >= #CreateODBCDateTime(cNow())# OR DateKill IS NULL)
33 : AND Visible = 1
34 : ORDER BY DateFlight DESC
|
|
| SQL |
SELECT *
FROM content_index
WHERE templateid =
AND DateFlight <= {ts '2008-05-09 17:56:23'}
AND (DateKill >= {ts '2008-05-09 17:56:23'} OR DateKill IS NULL)
AND Visible = 1
ORDER BY DateFlight DESC
LIMIT 0,1
|
| DATASOURCE |
goblueraiders |
| VENDORERRORCODE |
1064 |
| SQLSTATE |
23000 |
|
|
Resources:
|
| Browser |
CCBot/1.0 (+http://www.commoncrawl.org/bot.html) |
| Remote Address |
38.103.63.16 |
| Referrer |
|
| Date/Time |
09-May-08 05:56 PM |
|