> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 31 October 2008 10:25 > To: Bryce Nesbitt > Cc: dbi-users@perl.org > Subject: Re: Getting $sth->rows when selecting to a temporary table > > This sort of row count after select is highly depndant on the SQL database > you are running against. > > What is you DB? > > Is there a way in DBI to get a $sth->rows count, when selecting to a > > temporary table? > > > > In this code I get a proper count from the SELECT, but the SELECT INTO > > TEMPORARY TABLE returns -1. > > > > $dbh = DBI->connect(...); > > $sth = $dbh->prepare("SELECT data,name FROM saved_searches order by > > random()"); > > $sth->execute(); > > print "Rows=".$sth->rows."\n"; > > > > $sth = $dbh->prepare("SELECT data,name INTO TEMPORARY TABLE foo_1 FROM > > saved_searches order by random()"); > > $sth->execute(); > > print "Rows=".$sth->rows."\n"; > > > > > Don't know what DB you are using but I know I could not reliably use this with DBD::Oracle, I just did a count increment with each row in a fetch_array loop.
Stu Information in this email including any attachments may be privileged, confidential and is intended exclusively for the addressee. The views expressed may not be official policy, but the personal views of the originator. If you have received it in error, please notify the sender by return e-mail and delete it from your system. You should not reproduce, distribute, store, retransmit, use or disclose its contents to anyone. Please note we reserve the right to monitor all e-mail communication through our internal and external networks. SKY and the SKY marks are trade marks of British Sky Broadcasting Group plc and are used under licence. British Sky Broadcasting Limited (Registration No. 2906991), Sky Interactive Limited (Registration No. 3554332), Sky-In-Home Service Limited (Registration No. 2067075) and Sky Subscribers Services Limited (Registration No. 2340150) are direct or indirect subsidiaries of British Sky Broadcasting Group plc (Registration No. 2247735). All of the companies mentioned in this paragraph are incorporated in England and Wales and share the same registered office at Grant Way, Isleworth, Middlesex TW7 5QD.
