[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