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

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


Oops. :)

--Ben

------------------------

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: 216.3.30.103




At 01:21 PM 9/6/2001, you wrote:
><URL:http://members.evolt.org/djc/stdio/index.cfm/daddy/show/mommy/40>

-------------------------
Ben Dyer
Senior Internet Developer
Imaginuity Interactive
http://www.imaginuity.com
-------------------------
  Quidquid latine dictum
    sit, altum videtus.
-------------------------





More information about the thechat mailing list