SQL Update Increment Value

2002-04-01 Thread Eric J Hoffman
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)

RE: SQL Update Increment Value

2002-04-01 Thread VAN VLIET, SCOTT E (SBCSI)
: 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

RE: SQL Update Increment Value

2002-04-01 Thread Diana Nichols
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

Re: SQL Update Increment Value

2002-04-01 Thread Tim Painter
How about Update myTable Set myIntField = myIntField + 1 Where id = something - Original Message - From: Eric J Hoffman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 01, 2002 11:29 AM Subject: SQL Update Increment Value Is there a way to increment an int field