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 count

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