RE: Update query record count?

[Smith, Matthew P -CONT(CSC)]

I don't believe so.  If you are using a db that supports multiple SQL comands in onf cfquery tag, you could:

1.  do a select instead of the update first
2.  set an int(say, @myRowcount to @@rowcount
3.  run your update
4.  return @myRowcount AS RecordsUpdated

This is off the top of my head and there might be a better way, but that gets you what you need.

-----Original Message-----
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: 2/13/04 9:05 AM
Subject: Update query record count?

Is there a way to see how many (if any) records an update query has
updated
after it runs? Recordcount doesn't work.. Is there a way without doing
another
query?

Thanks,

Chris
  _____

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---