Re: accessing values in hash

Your first error is that you don't tell us the error message.

You might want to inspect the data structure you get back:

use Data::Dumper;

print Dumper $hash_ref;
[download]

In general, it helps very much to give a small, self-contained piece of code that reproduces the error. Even much better if that piece of code needs no external infrastructure like a database or whatnot.

Comment on Re: accessing values in hash Download Code

Replies are listed 'Best First'.
Re^2: accessing values in hash by mattdope (Acolyte) on Sep 03, 2006 at 23:23 UTC
ok, i now have: #fetch two colums (username , password) `while($hash_ref = $sth->fetchrow_hashref){ #dereference my %values=%$hash_ref; #print out usernames print $values{'username'};}` [download] I can print out all the usernames from the database but do you know how I can match one of these usernames to `$testUsername` [download] I need to print off something like "username matched"	[reply] [d/l] [select]
Re^3: accessing values in hash by swampyankee (Parson) on Sep 03, 2006 at 23:37 UTC
OK..let me get this straight. You're querying a database to get all usernames so you can use Perl to see if a given username is present? If that's the case -- and this isn't a rather odd homework assignment -- make the database do the work and write the query to see if the username is present. This way Perl would get a true/false answer from the database, and you wouldn't have to check 8,000,000 usernames In Perl, one way to do it would be to load all the usernames into an array and use grep `$yes = grep { /$username/ } @usernames;` [download] emc Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. Albert Einstein	[reply] [d/l]