On Wed, 2006-05-17 at 10:47 +1200, Dan Horne wrote:
> Nigel Metheringham wrote:
> >
> > Here's an example I have it returns all items in one table (TaskLog) old
> > than $fromdate and not referenced by another (task_last_run)
> >
> > my $rs = $schema->resultset('TaskLog');
> > my $subsel = '(SELECT tl_id FROM task_last_run)';
> > my $qry = $rs->search(
> > {
> > tl_timestamp => { '<=', $fromdate },
> > tl_id => { -not_in => \$subsel }
> > }
> > );
> >
> > The magic trick is the reference to a string containing raw SQL - this
> > is documented in the SQL::Abstract documentation.
> >
>
> Thanks, Nigel. I couldn't get this to work for me,
Well I was working on that about a month ago, and it worked then...
Today I finally managed to get back to this project, and it completely
fails to work :-)
So I guess there is a regression - from my point of view - between DBIC
0.060001 & 0.060002 (upgrade happened in that window).
I'll see if I can pin down whats happened and why.
Nigel.
--
[ Nigel Metheringham [EMAIL PROTECTED] ]
[ - Comments in this message are my own and not ITO opinion/policy - ]
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
