Re: selectall

Have you tried breaking it down and using fetchall_hashref instead? EG:

my $sql = "select Col1, Col2, Col3 from TABLE where Col4 = 1";
my $dbq = $dbh->prepare($sql);
$dbq->execute or die "Could not execute $sql:$!\n";
my $ref = $dbq->fetchall_hashref('Col1');
[download]

Comment on Re: selectall_hashref Download Code

Replies are listed 'Best First'.
Re^2: selectall_hashref by mnlight (Scribe) on Jan 05, 2006 at 04:52 UTC
Just tried doing the fetchall_hashref and got this error. "Can't locate object method "fetchall_hashref" via package DBI::st" Why does this stuff always happen to me?	[reply]
Re^3: selectall_hashref by McDarren (Abbot) on Jan 05, 2006 at 05:53 UTC
Which version of DBI do you have? From `perldoc DBI::Changes`, it appears that support for the fetchall_hashref method was added in version 1.20 (August 2001). If you don't have at least this version then you may want to grab the latest version. Cheers, Darren :)	[reply] [d/l]
Re^3: selectall_hashref by perrin (Chancellor) on Jan 05, 2006 at 05:59 UTC
What version of DBI do you have?	[reply]
Re^4: selectall_hashref by mnlight (Scribe) on Jan 05, 2006 at 06:31 UTC
I don't know how do I determine it.	[reply]
Re^5: selectall_hashref by perrin (Chancellor) on Jan 05, 2006 at 06:39 UTC
Re^5: selectall_hashref by jZed (Prior) on Jan 05, 2006 at 06:41 UTC
Re^3: selectall_hashref by spiritway (Vicar) on Jan 05, 2006 at 07:13 UTC
Why does this stuff always happen to me? Trust me - you're not the only one...	[reply]