I want to log the sql text of various queries into a log table.
When I try:
<cfset sqltext="Update labview set product_ID=#form.product_ID# where
ProdOrd_id=#form.prodOrd_ID#">
<cfquery name="ChangeLog" datasource="#application.datasource#">
insert into ChangeLog(actor, ChangeText, UpdateDate)
Values('#actor#','#sqltext#','#datenow#')
</cfquery>
I get errors like:
Incorrect syntax near the keyword 'Update'.
insert into ChangeLog(actor, ChangeText, UpdateDate)
Values('changeProduct,'Update project set product_ID=18 where
project_id=3016','17-Sep-07)
Is there some easy way to do this?
Rick Colman
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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-Talk/message.cfm/messageid:288672
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
