Re^3: Populating an array via a DBI call

by runrig (Abbot)

on Mar 29, 2017 at 20:56 UTC ( #1186436=note: print w/replies, xml )

Need Help??

If you don't really need the entire list of results in an array, you can just fetch one at a time like so:


my $sth = $dbh->prepare($sql);
$sth->execute();
$sth->bind_col( 1, \my $user_name );
while ( $sth->fetch() ) {
  print "$user_name\n";
}
[download]

Comment on Re^3: Populating an array via a DBI call - simplified Download Code

Domain Nodelet^?

Node Status^?

node history
Node Type: note [id://1186436]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others making s'mores by the fire in the courtyard of the Monastery: (5)

As of 2023-12-03 11:19 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

Notices^?