[thechat] Notice of Bar-bE-Volt 2001!

Ben Dyer ben_dyer at imaginuity.com
Thu Sep 6 13:40:31 CDT 2001

Oops. :)



Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)

[MERANT][ODBC MySql driver][MySql]You have an error in your SQL syntax near 
'order by posts.date desc' at line 8

SQL = "select posts.id as post_id, posts.date, date_format(posts.date, 
'%m/%d/%Y') as d2, posts.signoff, posts.title, posts.body, posts.blog_id, 
posts.user_id, posts.url, posts.anchor, usr.id, usr.login, usr.email from 
djc.posts, djc.usr where posts.blog_id = '5' and usr.id = posts.user_id and 
posts.signoff ='1' and posts.id = 40> order by posts.date desc"

Data Source = "DJC"

The error occurred while processing an element with a general identifier of 
(CFQUERY), occupying document position (38:5) to (38:48) in the template 
file /home/djc/public_html/stdio/show/act_show.cfm.

Date/Time: Thu Sep 6 13:39:31 2001
Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0; DigExt)
Remote Address:

At 01:21 PM 9/6/2001, you wrote:

Ben Dyer
Senior Internet Developer
Imaginuity Interactive
  Quidquid latine dictum
    sit, altum videtus.

More information about the thechat mailing list