Re: Detecting SQL Update success

2004-01-13 Thread Dan O'Keefe
Thank you Paul and Nate. Dan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Detecting SQL Update success

2004-01-12 Thread Dan O'Keefe
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]

Re: Detecting SQL Update success

2004-01-12 Thread Paul Hastings
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]

RE: Detecting SQL Update success

2004-01-12 Thread Nate Nelson
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