try using: #Evaluate('outcome_#ac_id#')#
Regards, Arsalan -------------------------------------------------- From: "Dakota Burns" <dakota.bu...@gmail.com> Sent: Saturday, October 23, 2010 9:34 PM To: "cf-talk" <cf-talk@houseoffusion.com> 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:338495 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm