[Dbix-class] problem with query using a column that doesn't exist

[Guillermo Roditi]

Thanks, nice to know im not just making an idiotic mistake for once.

Whats the deal with subselects? do they have an estimated landing
date? I mean, are they in planning, development, or prelim testing
stage?



On 7/11/06, Matt S Trout <dbix-class at trout.me.uk> wrote:
>
> On 11 Jul 2006, at 22:55, Guillermo Roditi wrote:
>
> > Hi, I am trying to execute the following query:
> >
> > $user->groups->search_related('items', { contact_id => $contact-
> > >id })->delete;
> >
> > which is generating this SQL:
> > DELETE FROM `djd_group_items` WHERE ( ( ( `contact_id` = ? ) AND (
> > `user_id` = ? ) ) )
> >
> > which makes no sense because user_id doesnt exist on that table....
> >
> > my table definitions are short and attached below.  can anyone help? i
> > am deeply confused about this one. im running of -current right now
> > but it was failing with _05 as well.
>
> Won't be supported until subselects land. Reformulate your query to
> not require joins.
>
> --
> Matt S Trout, Technical Director, Shadowcat Systems Ltd.
> Offering custom development, consultancy and support contracts for
> Catalyst,
> DBIx::Class and BAST. Contact mst (at) shadowcatsystems.co.uk for
> details.
> + Help us build a better perl ORM: http://dbix-
> class.shadowcatsystems.co.uk/ +
>
>
>
> _______________________________________________
> 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/
> Searchable Archive: http://www.mail-archive.com/dbix-class@lists.rawmode.org/
>