Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re^4: DB search results using DBI...execute

by poj (Abbot)
on Mar 05, 2017 at 08:51 UTC ( [id://1183690]=note: print w/replies, xml ) Need Help??


in reply to Re^3: DB search results using DBI...execute
in thread DB search results using DBI...execute

Try this simple cgi to show the benefit of using Dumper.

#!perl # Dumper demo cgi use strict; use Data::Dumper; print "Content-Type: text/html\n\n"; print '<pre>'; my $ref = [ { ID => 'ABC'},{ ID => 'DEF'},{ ID => 'GHI'} ]; print '<h2>$ref</h2>'; print Dumper $ref; print '<hr/>'; my @array = map { $_->{ID} } @$ref; print '<h2>@array</h2>'; print Dumper @array; print '<hr/>'; my @error = @array."\n"; print '<h2>@error</h2>'; print Dumper @error; print '<hr/>';

Also, note how map could be used to replace this code in search_item()

my @array = @$resultsRef foreach my $hit (@array) { # $hit is a hash reference. my %hash = %$hit; push @searched, $hash{ID}; }
poj

Replies are listed 'Best First'.
Re^5: DB search results using DBI...execute
by jamroll (Beadle) on Jun 20, 2017 at 15:55 UTC
    even better though, would be to drop the %hash = %$hit and write the push command as push(@searched, $hash->{ID}); which saves so much typing, and is much more readable and understandable...having to do "my %hit = ..." gets tedious - especially when yer imagination for new var names gets exhausted lol
Re^5: DB search results using DBI...execute
by jamroll (Beadle) on Jun 20, 2017 at 15:49 UTC
    haha! yes, yes - quite correct. it's been a long while since I looked at this thread, and I am so very happy that I changed this search_item to reflect how you wrote it. I recoded that routine long ago - so that makes me feel great and feel like i'm on the right track with that, so thank you very much! most cool

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others contemplating the Monastery: (5)
As of 2024-04-19 13:23 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found