Thank you Paul and Nate.
Dan
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Is there a way to detect if a SQL update statement in CFQUERY resulted in a record being updated? I guess I would want to know the number of rows updated.
Dan
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Is there a way to detect if a SQL update statement in CFQUERY resulted
in a record being updated? I guess I would want to know the number of rows
updated.
depends on your db, for sql server examine the @@ROWCOUNT var immediately
after your update.
[Todays Threads]
[This Message]
it helps,
Nate Nelson
-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED]
Sent: Monday, January 12, 2004 4:58 PM
To: CF-Talk
Subject: Re: Detecting SQL Update success
Is there a way to detect if a SQL update statement in CFQUERY
resulted
in a record being updated? I
4 matches
Mail list logo