Hello all Is there any way of doing this in one query?
i.e. I want to update a number field say people, If the current number in the table is 10 and I want to add 5 I can do two querys Select people.num from people update people Set num = (Q.num + newnum) have tried update people Setnum = (select num from people) + newnum can this be done in one query? thanks Rodney ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
