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)
: 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
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
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
4 matches
Mail list logo