Hi,
Mysql field names are case insensitive, but fetchrow_hashref requires you to use the exact field
case. I guess I could resolve this by looping thru the hash

for $key (keys %hashref)
{
$val =$hashref{$key};

$newhash{lc $key}=$val;

}

But what other options do I have?

(SORRY I realise this question must have a high Chestnut count for this NG)

zzapper (vim, cygwin, wiki & zsh)
--

vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?"

http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=ms...ie.nctu.edu.tw

Try searching for 'FetchHashKeyName' => 'NAME_lc' in the DBI docs.

uru Dave

zzapper wrote:
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=ms...ie.nctu.edu.tw

On Thu, 01 Jul 2004 20:06:24 +1000, wrote:


Thanx, exactly what I needed

while (my $hash_ref=$sel->fetchrow_hashref('NAME_lc'))
{

$postcode=$hash_ref->{'txtdevpostcode'};
$barrattid=$hash_ref->{'txtbarrattid'};
}


zzapper (vim, cygwin, wiki & zsh)
--

vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?"

http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=ms...ie.nctu.edu.tw