On Nov 16, 2007, at 3:26 AM, Ow Mun Heng wrote:
On Fri, 2007-11-16 at 10:22 +0100, Martijn van Oosterhout wrote:
On Fri, Nov 16, 2007 at 09:00:46AM +0800, Ow Mun Heng wrote:
I usually write a function which gets/uses the GETS DIAGNOSTIC
ROW COUNT
parameter which will tell me how many rows were affected by the
query.
Now, for this case, I'm not writing a function but merely using a
normal
SQL eg:
The server provides the number of changed rows in its response. Like
DELETE 2030. So check whatever you're using to run the commands.
The question is on how to use this number to be inserted into a table
instead of just being informational.
The specifics depend on what language you're using for your database
access. Regardless, though, save the server's response in a variable
and use that.
Erik Jones
Software Developer | Emma®
[EMAIL PROTECTED]
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend