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

Daniel J. Cody djc at starkmedia.com
Thu Sep 6 13:42:57 CDT 2001


you broke it!! ;)

did you get that just viewing the page? or trying to comment?

erf. coulda been a locking issue with mysql too

Ben Dyer wrote:
> 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.
> -------------------------
> 
> 
> _______________________________________________
> thechat mailing list
> thechat at lists.evolt.org
> http://lists.evolt.org/mailman/listinfo/thechat
> http://lists.evolt.org/thechatarchive/
> ________________
> "It's Friday.  Yeah! - only two more working days til Monday - Woooo!"






More information about the thechat mailing list