Re: sql syntax validator

2007-08-22 Thread Rick Root
What would be useful, is this... Since you're not using cfqueryparam (SHAME ON YOU!), you can do the following: Above the query, do this: INSERT INTO tblobject ( intobjectid, intobjecttypeid, strobjecttitle,

RE: sql syntax validator

2007-08-22 Thread SMR
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

RE: sql syntax validator

2007-08-22 Thread SMR
'#strcheckoutpermissions#', '#strcheckoutname#') -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?

Re: sql syntax validator

2007-08-22 Thread Greg Morphis
MySQL can do that. > > --BenD > > SMR wrote: > > Anyone know a sql syntax validator program that works with mysql ? > > > > > > > > ~| Create robust enterprise, web RIAs. Upgrade to C

Re: sql syntax validator

2007-08-22 Thread G Money
CTED] > 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

Re: sql syntax validator

2007-08-22 Thread Ben Doom
I think the query tool published by MySQL can do that. --BenD SMR wrote: > Anyone know a sql syntax validator program that works with mysql ? > > > ~| Download the latest ColdFusion 8 utilities including Report B

Re: sql syntax validator

2007-08-22 Thread Ben Doom
It was featured in Time. --BenD Greg Morphis wrote: > 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]&

RE: sql syntax validator

2007-08-22 Thread SMR
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&#

Re: sql syntax validator

2007-08-22 Thread Greg Morphis
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 s

sql syntax validator

2007-08-22 Thread SMR
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