Outstanding response to my question here on CF-Talk! Thank you very much Dave, Arsalan, Russ, and Enigment -- the variety of your responses showing differing ways to accomplish this simple task is great.
Thanks again! Dakota On Sat, Oct 23, 2010 at 11:34 AM, Dakota Burns <dakota.bu...@gmail.com>wrote: > 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:338501 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm