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 ? > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:241009 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
