[jifty-devel] Jifty::DBI order_by unclear

Agent Zhang agentzh at gmail.com
Mon May 28 20:03:42 EDT 2007


On 5/29/07, Agent Zhang <agentzh at gmail.com> wrote:
>     my $sessions = $self->new_alias('sessions');
>     $self->join(
>         column1 => 'msg_session',
>         alias2  => $sessions, column2 => 'id');
> [snip]
> select *
> from messages as main, sessions as sessions_1
> where [...]
> order by sessions_1.begin_time desc, session_offset asc
>

Well, some join-related components in the where clause shouldn't be omitted:

  where msg_session = sessions_1.id and [...]

It may be worth mentioning that 'sessions_1' is generated by the
C<new_alias> method IIRC :)

Cheers, agentz


More information about the jifty-devel mailing list