[Dbix-class] updating a has_many relationship failure

2010-02-02 Thread Jon
Hello, I'm building a Catalyst app using dbix class. This is the first app I have built using dbix-class but I have a large part of the app built when I came across this issue. When I attempt to update a column in a row with a has_many relationship I get the following error, and the update

RE: [Dbix-class] updating a has_many relationship failure

2010-02-02 Thread Ihnen, David
It expects the object of the opposing table row there, not a hash - hence the error. This is how I would do it. $album-update({ record_label = App-model('AppDB::Labels')-find({ label_name = Dischord }) }); David -Original Message- From: Jon [mailto:j...@texttoall.com] Sent: Tuesday,

[Dbix-class] paging question

2010-02-02 Thread James Marca
Hi. First DBIx::Class is excellent and kudos all around. I have recently needed to use the paging feature for the first time and I'm not sure of the best way to do this. First a simple question: How should one terminate the paging? Is there some variable to check to find out how many pages

Re: [Dbix-class] paging question

2010-02-02 Thread James Marca
On Tue, Feb 02, 2010 at 11:14:27AM -0800, James Marca wrote: Hi. First DBIx::Class is excellent and kudos all around. I have recently needed to use the paging feature for the first time and I'm not sure of the best way to do this. First a simple question: How should one terminate the

Re: [Dbix-class] updating a has_many relationship failure

2010-02-02 Thread Jon
It expects the object of the opposing table row there, not a hash - hence the error.  This is how I would do it. Thanks David, works great now. ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN:

Re: [Dbix-class] Cross-schema relationships.

2010-02-02 Thread Aaron Crane
Rob Kinyon rob.kin...@gmail.com wrote: If you're talking about different physical DB instances and there's no feature in the DBMS to manage those cross-connections for you, then you have to do it by hand. Suggestions for API improvements welcome. I've done something similar recently. My

[Dbix-class] Re: Validating column data

2010-02-02 Thread Bill Moseley
Ok, here's a more specific question. Is there a way to generate an empty result set? For example, I want to test the search criteria and return an empty result set (or undef) if it fails the test. I guess this is one way, but it will mean an unnecessary trip to the database: sub search_rs {