BTW to clear a hash you want to '%storedProfile = ()'
[download]

actually -- thats what i have in my code.. the $ was a sloppy typo in the browser :)

while (my $row = $sth->fetchrow_hashref)
[download]

i do that when i'm expecting more than one row -- but in this case, i'm searching by a unique key, so there can only be one row -- the while loop isn't necessary :) thanks to all.. i'm gonna test this all..

    %storedProfile=%{$query->fetchrow_hashref};
[download]

seems to do what i want, though i'm worried what would happen if there's more than 1 result row...