Re: [Catalyst] LEFT JOIN with AND statement

On Tue, Mar 17, 2009 at 9:55 PM, Jakub Tutaj wrote: > > Hello! > > I'd like to prepare query like: > SELECT group_tasks.*,student_tasks.* > FROM group_tasks > LEFT JOIN student_tasks > ON group_tasks.id = student_tasks.group_task_id AND student_tasks.user_id = > 1 > WHERE group_tasks.group_id = 1

[Catalyst] LEFT JOIN with AND statement

Hello! I'd like to prepare query like: SELECT group_tasks.*,student_tasks.* FROM group_tasks LEFT JOIN student_tasks ON group_tasks.id = student_tasks.group_task_id AND student_tasks.user_id = 1 WHERE group_tasks.group_id = 1 I stuck at this point: $c->stash->{studentgrouptasks} = [$c->mode

Re: [Catalyst] Catalyst::Plugin::Captcha

Emmanuel Quevillon wrote: Octavian Râsnita wrote: From: "Emmanuel Quevillon" Better use Catalyst::Controller::HTML::FormFu. You can easy add reCAPTCHA with it. reCAPTCHA also creates an audio file so more human beeings would be able to pass it. Sure, but reCAPTCHA needs that you regsiter