<?xml version="1.0" encoding="windows-1252"?>
<node id="51466" title="How to get number of rows updated in by an sql statement? (Win32::ODBC)" created="2001-01-12 19:35:34" updated="2005-08-15 10:44:57">
<type id="1857">
categorized question</type>
<author id="11732">
QandAEditors</author>
<data>
<field name="doctext">
I am using [mod://Win32::ODBC] and SQL Server 7.&lt;BR&gt;
I write an update query to the DB, and I would really like to be able to get back the number of rows updated.&lt;BR&gt;
&lt;BR&gt;
The [mod://Win32::ODBC] man page says:

&lt;blockquote&gt;
&lt;I&gt;
Sql( SQL_STRING )&lt;BR&gt;
&lt;br&gt;
Executes the SQL command SQL_STRING on the current connection. &lt;br&gt;
Returns ? on success, or an error number on failure.
&lt;/I&gt;
&lt;/blockquote&gt;
&lt;p&gt;

but as far as I can tell, &lt;tt&gt;Sql()&lt;/tt&gt; isn't returning anything after my update query.

 

</field>
<field name="parent_node">
1831</field>
</data>
</node>
