|gavy||-- 02-24-2008 @ 12:26 PM|
i got this query from my colleage as i was also unable to solve this:
this is like as:
table1.quest = quest - COUNT(#form.delmode#)
ID IN (<cfqueryparam cfsqltype="cf_sql_numeric" value="#trim(ID)#" list="yes">)
form.delmode gets the value from the page where the values come as: 9,11,14,21,33
that comes up to 5
so what he wants is:
update table1 set table1 - COUNT(#form.delmode#) in this case say 5
hope anyhow this gets up working..
<< << ArrowHead >> >>
......Come and growl......
|EasyCFM.COM ColdFusion Forums :||http://archive.easycfm.com/forums|