Re: [Dbix-class] SQL::Abstract 1.50

2009-02-16 Thread BUCHMULLER Norbert
On Sun, 15 Feb 2009 21:45:52 +0100 Zbigniew Lukasiak wrote: But talking about irc - I've seen you mention that -search({col = \[func(?), $val]}) would still not work now - why is that? Because DBIC creates SQLA instances with {bindtype = 'columns'}, and SQLA in the 'columns' bind type mode

Re: [Dbix-class] SQL::Abstract 1.50

2009-02-16 Thread BUCHMULLER Norbert
On Mon, 16 Feb 2009 09:43:28 +0100 BUCHMULLER Norbert wrote: I wanted a more straightforward syntax for the above case, mst refused to listen to me. OK, we sorted it out. In short: * SQLA 1.50 is just a temporary solution before we implement 2.0 * people are not supposed to use plain SQL

Re: [Dbix-class] SQL::Abstract 1.50

2009-02-15 Thread BUCHMULLER Norbert
On Sat, 14 Feb 2009 17:59:38 +0100 Zbigniew Lukasiak wrote: There was a discussion at IRC about the need for -in to accept a subquery. Like this: my $cdrs2 = $cdrs-search({ artist = { -in = $art_rs-get_column( 'artistid' )-as_query, }, }); I am attaching a simple

[Dbix-class] SQL::Abstract 1.50

2009-02-13 Thread Zbigniew Lukasiak
Hi, The 0.08011 release of DBIC, introduced for compatibility with the new SQL::Abstract, is now on CPAN. What is now holding the SQL::Abstract release? -- Zbigniew Lukasiak http://brudnopis.blogspot.com/ http://perlalchemy.blogspot.com/ ___ List:

Re: [Dbix-class] SQL::Abstract 1.50

2009-02-13 Thread Peter Rabbitson
Zbigniew Lukasiak wrote: Hi, The 0.08011 release of DBIC, introduced for compatibility with the new SQL::Abstract, is now on CPAN. What is now holding the SQL::Abstract release? The first release candidate is already on CPAN. http://search.cpan.org/~mstrout/SQL-Abstract-1.49_01/ Get it