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,
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
'#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?
Since the version of MySQL is the same.. makes me wonder if it's a
problem with CF. What's the query you're trying.. there's tons of
experts here that can help.
Thank you drive thru
On 8/22/07, Ben Doom <[EMAIL PROTECTED]> wrote:
> I think the query tool published by MySQL can do that.
>
> --BenD
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
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 Builder,
plug-
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]> wrote:
>> Anyone know a sql syntax validator program that works with
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&#
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 ?
>
>
>
