Richard Colman wrote:
>
> <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>
Try cfqueryparam.
Jochem
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288675
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
