On Thu, Jul 10, 2008 at 7:44 AM, Amit Saxena <[EMAIL PROTECTED]> wrote: > Hi all, > > I want to know how to get the count of number of rows returned in delete / > update sql in Perl DBI ? > > I have ready some articles on the internet and it states that the "execute" > function returns the number of rows affected though it's not confirmed to > work for all the database. > > Is there any solution which will surely work on all databases ? > > Thanks & Regards, > Amit Saxena >
The CPAN page says execute() returns the number of rows affected... I'm not sure why that would be doubted. You can always do a "SELECT COUNT" query first to get the count of rows that match the given condition. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/