fetchrow_hashref and field name case-sensitivity

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=gcdmp-msql-mysql-modules [at] m .gmane.org
zzapper [ Do, 01 Juli 2004 11:09 ] [ ID #180716 ]
Datenbanken » gmane.comp.db.mysql.perl » fetchrow_hashref and field name case-sensitivity

Vorheriges Thema: fetchrow_hashref and field name case-sensitivity
Nächstes Thema: Inserting and retrieving id