Re: Tie::DBI question

I (sorta) found the problem. Apparently, Tie::DBI can't handle ANY field that has a mixed case name. It wasn't the DATE that was tripping it up. dateCreated and songsPlayed wouldn't be set at all, whereas nick, hostmask, level, credits, and moderates would. changing them to songs_played and date_created fixed it.

Comment on Re: Tie::DBI question

Replies are listed 'Best First'.
Re: Re: Tie::DBI question by merlyn (Sage) on May 07, 2001 at 07:46 UTC
From Tie::DBI: `# if we get here, we can fetch the names of the fields my %fields = map { lc($_)=>1 } @{$sth->{NAME}};` [download] See that nice "lc"? I suspect that since field names are case insensitive on the DB side, but hashes are not, the author presumed that you'd always use lowercase. So I bet you didn't need to change your database... just your access code. -- Randal L. Schwartz, Perl hacker	[reply] [d/l]
Re^2: Tie::DBI question by geektron (Curate) on Jun 28, 2005 at 22:37 UTC
you could also set the CASESENSITIV flag to a non-zero number.	[reply]