You just output them individually, as you are using them in a query you need do nothing more
Set outcome = '#form.outcome##form._ac_id#' Russ -----Original Message----- From: Dakota Burns [mailto:[email protected]] Sent: 23 October 2010 17:34 To: cf-talk Subject: How to Capture Field Name with Two Input Variables Hi - I have a form that contains an outcome field, which has an "_#ac_id" appended to it so I can properly identify it (their can be many fields passed in). I seem to be at a loss for how to output what appears to be two variables as one ('#outcome_#ac_id##' -- see below query). Is their a way to properly concatenate these or another recommended method? Thank you. Dakota -- Referenced Query UPDATE nonprofitContacts SET outcome = '#outcome_#ac_id##' WHERE nonprofitContacts_id = '#ac_id#' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338496 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
