selectall_hashref

mnlight has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: selectall_hashref by Errto (Vicar) on Jan 04, 2006 at 23:57 UTC
I hate to be one to blame bugs in the system, but in this case it looks like it might be a bug in DBD::Sybase because I tried essentially the same code with DBD::Oracle and did not get an error like that. Make sure you have upgraded to the latest versions. Then try it using a named column as the index indstead of a number, just to better isolate the problem. If this doesn't fix it you might want to report the bug. (note that mpeppler is something of a regular here) However, please also follow smokemachine's advice because otherwise once this error is dealt with you fill still find that you don't have any data being returned.	[reply]
Re^2: selectall_hashref by mpeppler (Vicar) on Jan 05, 2006 at 07:12 UTC
It's not a bug in DBD::Sybase - I just tried this and it worked for me. So I'm guessing (as others have) that the OP has an old version of DBI. Michael	[reply]
Re: selectall_hashref by jZed (Prior) on Jan 04, 2006 at 23:32 UTC
What is "1" as the second parameter to selectall_hashref()? That parameter should be the name of the column you want to use as a key, e.g. 'Col1', not an integer.	[reply]
Re^2: selectall_hashref by mnlight (Scribe) on Jan 04, 2006 at 23:35 UTC
I have tried that and it has the same result. The doc I read said you could indicate the column by location.	[reply]
Re: selectall_hashref by smokemachine (Hermit) on Jan 04, 2006 at 23:01 UTC
try `while ( ($k,$v) = each %$data_all ) {`	[reply] [d/l]
Re^2: selectall_hashref by mnlight (Scribe) on Jan 04, 2006 at 23:22 UTC
Still not working. If I remove the second parameter selectall_hashref($sql) I recieve this error "Bad index while coercing array" With a second parm, either col location or col name I get the original error.	[reply]
Re: selectall_hashref by McDarren (Abbot) on Jan 05, 2006 at 00:59 UTC
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]	[reply] [d/l]
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
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]
Re: selectall_hashref by runrig (Abbot) on Jan 04, 2006 at 22:56 UTC
The document I read said that the second parameter is "the column to use as key, indicated by position". What document was that? Look at the docs for fetchall_hashref, it works the same way (except you have to call prepare and execute), and has an example: `$dbh->{FetchHashKeyName} = 'NAME_lc'; $sth = $dbh->prepare("SELECT FOO, BAR, ID, NAME, BAZ FROM TABLE"); $sth->execute; $hash_ref = $sth->fetchall_hashref('id'); print "Name for id 42 is $hash_ref->{42}->{name}\n";` [download] Update: I do also see this for fetchall_hashref, so you may be right (in some other version of documentation from mine), but try it both ways: `The $key_field parameter can also be specified as an integer column nu +mber (counting from 1).` [download] Update: nevermind...see correct answer below.	[reply] [d/l] [select]
Re: selectall_hashref by BaldPenguin (Friar) on Jan 05, 2006 at 06:32 UTC
When I pull a query like that, I normally do it like: `my $dbh = DBI->connect('DBI:Sybase:#####', '#####', '#####', { RaiseE +rror => 1, AutoCommit => 1}); my $sql = "select Col1, Col2, Col3 from TABLE where Col4 = 1"; my $data_all = $dbh->selectall_arrayref($sql, { 'Columns' => {} } ); for my $row ( @$data_all ) { print "$_ => $row->{$_}\n" for keys %$row; }` [download] Will that do what you are looking for. Don WHITEPAGES.COM \| INC Everything I've learned in life can be summed up in a small perl script!	[reply] [d/l]
Re^2: selectall_hashref by mnlight (Scribe) on Jan 05, 2006 at 06:43 UTC
I resorted back to my old way. Thank you for your help.	[reply]
Re^3: selectall_hashref by Anonymous Monk on Apr 22, 2013 at 14:11 UTC
That is because you must include the name of the column in uppercase letters, instead of 'Col1', use 'COL1'.	[reply]
Re^4: selectall_hashref by iza (Monk) on Nov 12, 2014 at 11:00 UTC


Don't ask to ask, just ask
	PerlMonks