[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