Re: Mixed-case column names breaking under Class::DBI

As far as I can see, the only problem is that your column name "user" is a SQL reserved keyword. Change the name of that column (in the database and in the code), remove all of the quotes around all of the column names, and everything should work, it does for me.

Comment on Re: Mixed-case column names breaking under Class::DBI

Replies are listed 'Best First'.
Re^2: Mixed-case column names breaking under Class::DBI by sintadil (Pilgrim) on Sep 20, 2004 at 21:38 UTC
As far as I can see, the only problem is that your column name "user" is a SQL reserved keyword. Change the name of that column (in the database and in the code), remove all of the quotes around all of the column names, and everything should work, it does for me. Okay, bad column choice on my part. However, my FTP server doesn't have a problem with it because it quotes the column name. That functionality is what I'm trying to accomplish with the quoting.	[reply]
Re^3: Mixed-case column names breaking under Class::DBI by Aristotle (Chancellor) on Sep 20, 2004 at 21:42 UTC
Sounds like you should file a bug asking for Class::DBI to quote column names. Makeshifts last the longest.	[reply]
Re^4: Mixed-case column names breaking under Class::DBI by sintadil (Pilgrim) on Sep 20, 2004 at 21:45 UTC
I was thinking about filing a bug, but I wanted to make sure that it wasn't a PEBKAC first. I'm off to do so now, though.	[reply]