yes. update tableA set fieldA = 1 since YOU are updateing the table you already know what the value will be. Of course, you could clarify your question.
On Thu, 15 Nov 2001, Robert Everland wrote: > Is there anyway I can get the value of a field that I update without > having to do a query first. > > Robert Everland III > Dixon Ticonderoga > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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

