Re: [Dbix-class] SQL::Abstract : adding support for two potentially MySQL-specific functions

2009-03-11 Thread BUCHMULLER Norbert
On Sun, 8 Mar 2009 13:49:36 -0500 Rob Kinyon wrote: > The rewrite of SQL::Abstract will support the concept of SQL dialects, > so that would fit in very nicely - if it was done. I'm not one of the > current maintainers, but I think that if you were to provide a patch > off of http://dev.catalyst.p

Re: [Dbix-class] Patch submission: Relationship Accessor for null pattern compatibility

2009-03-11 Thread David Ihnen
Peter Rabbitson wrote: David Ihnen wrote: When working with the null pattern classes from Mr. Rabbitson, I discovered this slight ommission that results in getting an undefined, when you're actually wanting a null. That is, even when something is not true, I still want it! It should be enti

Re: [Dbix-class] Patch submission: Relationship Accessor for null pattern compatibility

2009-03-11 Thread Peter Rabbitson
David Ihnen wrote: > When working with the null pattern classes from Mr. Rabbitson, I > discovered this slight ommission that results in getting an undefined, > when you're actually wanting a null. That is, even when something is > not true, I still want it! It should be entirely backwards compat

Re: [Dbix-class] Pagination Troubles

2009-03-11 Thread Jess Robinson
On Thu, 5 Feb 2009, fREW Schmidt wrote: Hi all! I am trying to paginate some results and I need to get the count of the full results. I tried to use count and that only gives the amount that are in the current result set. I tried to do this: http://lists.scsys.co.uk/pipermail/dbix-class/2006

Re: [Dbix-class] InflateColumn::DateTime, inheritance, and insert/delete problems

2009-03-11 Thread Peter Rabbitson
Steve Caldwell wrote: > Consider the following script: > > #!/usr/bin/perl > use strict; > use warnings; > > # mysql> > # create database foo; > # create table foo.tblfoo ( > # fooid integer not null auto_increment, > # mydate datetime, > # primary key (fooid) > # ); > # grant

Re: [Dbix-class] Get a list of parent objects based on child object properties (possible n00bish question)

2009-03-11 Thread Jess Robinson
To answer the bits of your qyestion that nobody else did: On Tue, 3 Feb 2009, Mon-Chaio Lo wrote: Hello, I couldn't find the answer to this question in the documentation, so I turn to the community. I have the following example tables: projects pid namestatus 1 proj1 compl