Jayce writes: > > how many rows are returned, so I can set up my x, y axis right. > > my $number_rows = $csr->rows; > > easy ;D
Not so easy: I cite from the DBI perldoc: Generally, you can only rely on a row count after a non-SELECT execute (for some specific operations like UPDATE and DELETE), or after fetching all the rows of a SELECT statement. It won't help Shao unless the query has already executed the statement has fetched all the results. Shao's desire is to know before fetching the data. Stph
