Thanks all yet again for you valuable input. I have managed to do a row count by putting the contents of the fetch_throwarray() method in a array and evaluating its length that way.
"Stevenson, Jonathan" wrote: > > If you read through the dbi docs, you will see that you cannot rely on the rows >method using SELECT - it should only be trusted for non-select methods. > > to quote 'some drivers may return 1- until all rows have been fetched.' > > You would do better to do a SELECT COUNT(*).... statement, or fetch all the rows >using fetchall_arrayref, and evaluate the number of rows in the output. > > Jon > > -----Original Message----- > From: Jas Grewal [mailto:[EMAIL PROTECTED]] > Sent: 24 May 2002 11:45 > To: [EMAIL PROTECTED] > Subject: rows result on a query handle. > > Hi All, > > I am using DBD::ODBC to connect to a Informix database on a remote > machine, every thing seems to be going fine. Except that when I try > to get the number of rows returned by a query using the syntax bellow > : > > if($sth->rows==0){ > .... do something > } > > The problem is that I know that the row does not exist so I would > expect it to (.. do something), but it dosent. I get a value of '-1' > instaed of '0'. Any ideas why im getting the '-1' value instaed of > '0'???
