These look to be subqueries in a SELECT clause. subqueries are supported in the latest dev release.
Rob On Thu, Mar 12, 2009 at 11:23, fREW Schmidt <[email protected]> wrote: > Hello friends! > > We have the following SQL: > >> (select date from logParents where id = 62), >> (select max(logstatus.date) from logstatus >> join logChildren on logChildren.id = logStatus.child_id >> join logParents on logParents.id = logChildren.parent_id >> where parent_id = 62) >> ) as elapsed > > We'd like to make it a method for the logParent, so one could just do > $parent->elapsed_ms or something like that. We are kindav at a loss as to > how to do this. Any tips at all would be extremely helpful. > > Thanks! > > -- > fREW Schmidt > http://blog.afoolishmanifesto.com > > _______________________________________________ > List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class > IRC: irc.perl.org#dbix-class > SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ > Searchable Archive: > http://www.grokbase.com/group/[email protected] > -- Thanks, Rob Kinyon _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
