I found out its two fields, one is a bit field and one is an integer field.
-----Original Message----- From: G Money [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 22, 2007 10:27 AM To: CF-Community Subject: Re: sql syntax validator Care to throw it out there and let all of us gander at it? Maybe something will stick out..... On 8/22/07, SMR <[EMAIL PROTECTED]> wrote: > > Well myself and 2 db admins have looked at the query that throws and > error and don't understand where the error is coming from especially > when the query in the CF page runs fine on CF8/mysql 5.0.17 but blows > up on CF7/mysql > 5.0.17 and tells me there is a sql syntax error. Does CF8 have some > kind of "autofix" now ? > > -----Original Message----- > From: Greg Morphis [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 22, 2007 10:11 AM > To: CF-Community > Subject: Re: sql syntax validator > > Sure it's called 'you'.. > It's the best and when properly learned 'you' can recognize format > errors and fix them 'you'rself. > > > > On 8/22/07, SMR <[EMAIL PROTECTED]> wrote: > > Anyone know a sql syntax validator program that works with mysql ? > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:241016 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5