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:
<cfsavecontent variable="foo"><cfoutput>
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#')
</cfoutput></cfsavecontent>
Then you can either do this:
<cfoutput>#foo#</cfoutput><cfabort>
Or drop the value of "foo" into an email to yourself t osee the actual
query code that's being generated.
Alternatively, use cfqueryparam on *ALL* of the fields.. I'd be
willing to be that would help solve your problem.
Rick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:241035
Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
