How about this: <cfquery> update Table set IntField = (select IntField from Table where ID=Whatever) +1 where ID=Whatever </cfquery>
--Not tested, but it's where I would start. HTH D ************************ Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374 -----Original Message----- From: Eric J Hoffman [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 11:30 AM To: CF-Talk Subject: SQL Update Increment Value Is there a way to increment an int field in sql via the update statement without doing a select query in cf, then an update? Thanks for filling the hole. Regards, Eric J. Hoffman Director of Internet Development DataStream Connexion, LLC (formerly Small Dog Design) ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
