>>INSERT INTO mytable ( myNAME )
VALUES ( '#evaluate("form.myNAME#idx#")#' )
The problem is caused by the way the automatic single quote escaping
process works (or does not work) in CF:
It only applies to variables, not to expressions.
The solution is then to evaluate your expression in a variable outside
the QUERY, ie:
<CFSET myValue = form.['myNAME' & id]>
<CFQUERY....
INSERT INTO mytable ( myNAME )
VALUES ('#myValue#')
....
--
_______________________________________
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278854
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
