Gossamer Forum
Home : Products : Gossamer Forum : Development, Plugins and Globals :

Re: [kencl] Scripts for last 10 posting

Quote Reply
Re: [kencl] Scripts for last 10 posting In reply to
Hi,

See the docs on GT::SQL::Condition, it's what should be used for any advanced where clauses.

my $cond = GT::SQL::Condition->new('post_moved', '<>', 1);
$table->select($cond);

To do the select distinct, you would do:

$table->select('DISTINCT(column)', $cond);

Cheers,

Alex
--
Gossamer Threads Inc.
Subject Author Views Date
Thread Scripts for last 10 posting bgkhoo 13664 Dec 3, 2001, 7:40 AM
Post Re: [bgkhoo] Scripts for last 10 posting
Wil 13461 Dec 3, 2001, 7:42 AM
Thread Re: [bgkhoo] Scripts for last 10 posting
Paul 13473 Dec 3, 2001, 8:14 AM
Thread Re: [PaulW] Scripts for last 10 posting
bgkhoo 13434 Dec 3, 2001, 9:52 AM
Post Post deleted by PaulW
Paul 13419 Dec 3, 2001, 10:36 AM
Thread Re: [bgkhoo] Scripts for last 10 posting
Paul 13431 Dec 3, 2001, 11:02 AM
Post Post deleted by kjetilpa
kjetilpa 13359 Jul 31, 2002, 1:54 AM
Thread Re: [Paul] Scripts for last 10 posting
Jag 13253 Sep 2, 2002, 7:03 AM
Thread Re: [Jag] Scripts for last 10 posting
Paul 13303 Sep 2, 2002, 7:36 AM
Post Re: [Paul] Scripts for last 10 posting
Jag 13218 Sep 2, 2002, 7:43 AM
Post Re: [Paul] Scripts for last 10 posting
Jag 13200 Sep 2, 2002, 7:53 AM
Thread Re: [Paul] Scripts for last 10 posting
Jag 13212 Sep 2, 2002, 9:04 AM
Thread Re: [Jag] Scripts for last 10 posting
maxpico 13181 Sep 4, 2002, 12:41 PM
Post Re: [maxpico] Scripts for last 10 posting
Jag 13121 Sep 5, 2002, 6:57 AM
Post Re: [Paul] Scripts for last 10 posting
mick31 2307 Aug 1, 2003, 12:33 PM
Thread Re: [Paul] Scripts for last 10 posting
Sir Up 13090 Oct 4, 2002, 11:41 AM
Thread Re: [Sir Up] Scripts for last 10 posting
Paul 13086 Oct 4, 2002, 12:30 PM
Post Re: [Paul] Scripts for last 10 posting
Sir Up 13068 Oct 4, 2002, 12:51 PM
Thread Re: [Paul] Scripts for last 10 posting
kencl 12632 Feb 3, 2003, 3:32 PM
Thread Re: [kencl] Scripts for last 10 posting
yogi 12666 Feb 4, 2003, 1:22 AM
Thread Re: [yogi] Scripts for last 10 posting
kencl 12588 Feb 4, 2003, 1:01 PM
Thread Re: [kencl] Scripts for last 10 posting
kencl 12554 Feb 21, 2003, 9:48 AM
Thread Re: [kencl] Scripts for last 10 posting
Alex 12541 Feb 26, 2003, 12:59 AM
Thread Re: [Alex] Scripts for last 10 posting
kencl 12444 Mar 18, 2003, 4:54 PM
Thread Re: [kencl] Scripts for last 10 posting
Alex 12480 Mar 18, 2003, 5:04 PM
Post Re: [Alex] Scripts for last 10 posting
kencl 12455 Mar 18, 2003, 5:15 PM
Post Re: [bgkhoo] Scripts for last 10 posting
rmurdo 1873 Nov 15, 2008, 6:30 PM