Query is below. If I take out blncheckout and intcheckoutgroupid it works.
With either of those in it blows up on CF7 but works on CF8.
<Cfquery name="updateInfo" datasource="riskjava">
INSERT INTO tblobject (
intobjectid,
intobjecttypeid,
strobjecttitle,
intobjectstatusid,
intobjecttypestatusid,
strxmldata,
intobjectsize,
intobjectownergroupid,
dtobjectcreatedate,
dtobjectlastmodifieddate,
intobjectlastmodifiedid,
intprojectid,
strobjectspecificicon,
blncheckout,
intcheckoutgroupid,
dtcheckout,
strcheckoutpermissions,
strcheckoutname
)
VALUES (#intobjectid#,
#intobjecttypeid#,
'#strobjecttitle#',
#intobjectstatusid#,
#intobjecttypestatusid#,
'#strxmldata#',
#intobjectsize#,
#intobjectownergroupid#,
#createodbcdate(dtobjectcreatedate)#,
#createodbcdate(dtobjectlastmodifieddate)#,
#intobjectlastmodifiedid#,
#intprojectid#,
'#strobjectspecificicon#',
'#blncheckout#',
#intcheckoutgroupid#,
#createodbcdate(dtcheckout)#,
'#strcheckoutpermissions#',
'#strcheckoutname#')
</cfquery>
-----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 ?
> >
> >
> >
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive:
http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:241017
Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
