Jas,
I'd have to see the code, but it could be the query is failing, in general.
The rowcount is set to -1 by default and changed when we can find more
information about the row count. I'd like to see a DBI trace at level 9 to
see what's happening.
THanks,
Jeff
>
> 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'???
