Re^2: DBIx::Class::Schema::Loader prob


good chemistry is complicated, and a little bit messy -LW
	PerlMonks

Re^2: DBIx::Class::Schema::Loader prob

by jfrm (Monk)

on Aug 24, 2006 at 13:10 UTC ( [id://569356]=note: print w/replies, xml )

Need Help??

in reply to Re: DBIx::Class::Schema::Loader prob
in thread DBIx::Class::Schema::Loader prob

What the debugger did reveal is that the Loader seems to be changing the case of my column names. So while the following worked previously:

print "! ".$country->CountryCode." = ".$country->CountryName;

once the columns have been loaded with the Loader it fails but this works instead:

print "! ".$country->countrycode." = ".$country->countryname;

I thought this behaviour might be an option but I've looked all through DBIx::Class::Schema::Loader::Base documentation and can't see anything pertaining. Is this a bug or by design?

Comment on Re^2: DBIx::Class::Schema::Loader prob Select or Download Code

Replies are listed 'Best First'.
Re^3: DBIx::Class::Schema::Loader prob by insaniac (Friar) on Aug 24, 2006 at 20:44 UTC
I think this is because column names are not case sensitive in MySQL ;-) google reveals a lot ;-) to ask a question is a moment of shame to remain ignorant is a lifelong shame	[reply]

In Section Seekers of Perl Wisdom

Domain Nodelet^?

www.com | www.net | www.org

Node Status^?

node history
Node Type: note [id://569356]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others goofing around in the Monastery: (2)

As of 2024-04-25 19:08 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Today I Learned

Voting Booth^?

No recent polls found