Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re: sql record sets

by pope (Friar)
on Sep 16, 2002 at 08:04 UTC ( #198178=note: print w/replies, xml ) Need Help??


in reply to sql record sets

DBI doesn't support scrollable cursor, if that's what you're looking for. If you want to "walk" on the result set, you may consider using the $dbh->selectall_arrayref() method which returns the whole result set as an array ref of array refs.
use Data::Dumper; ... $rows = $dbh->selectall_arrayref("SELECT ..."); # the first row: print Dumper $rows->[0];

Update: fixed typo

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://198178]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (4)
As of 2020-01-18 14:22 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Notices?