Beefy Boxes and Bandwidth Generously Provided by pair Networks
Come for the quick hacks, stay for the epiphanies.
 
PerlMonks  

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

by sintadil (Pilgrim)
on Sep 20, 2004 at 21:38 UTC ( [id://392507]=note: print w/replies, xml ) Need Help??


in reply to Re: Mixed-case column names breaking under Class::DBI
in thread 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.

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.

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

Replies are listed 'Best First'.
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.

      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.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://392507]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others studying the Monastery: (7)
As of 2024-04-19 17:59 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found