Re: fetchrow_array vs fetchrow_arrayref question

2004-09-13 Thread Hardy Merrill
Generally the "rows" method is unreliable - here's a section from 'perldoc DBI': "rows" $rv = $sth->rows; Returns the number of rows affected by the last row affecting command, or -1 if the number of rows is not known or not available. Generally, you can only rely on a row coun

fetchrow_array vs fetchrow_arrayref question

2004-09-12 Thread Zhiliang Hu
Case: When I used $query_a->fetchrow_array I use it again in $query_a->rows to count number or rows. However, when I used $query_a->fetchrow_arrayref $query_a->rows returns nothing - it seems $query_a is nullified. Is it normal or due to my other problem? Thanks in advance! Zhiliang