Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: Using GT::SQL::Condition, and options in select?

Aug 27, 2003, 1:28 AM

Andy

Veteran / Moderator (18441 posts)

Aug 27, 2003, 1:28 AM

Post #1 of 5

Shortcut

Using GT::SQL::Condition, and options in select?

Hi. Does anyone know how I could acheive the following;

my $cond = GT::SQL::Condition->new( 'Top_Order', '>', '0' );
$sth = $table->select( { isValidated => 'Yes' }, { CategoryID => $cat_id }, $cond );

Basically, I want to select any links where Top_Order IS > than 0, and CategoryID => $cat_id (CatLinks), and isValidated = 'Yes' in the 'Links' table.

It works fine if I don't use the GT::SQL::Condition... so I'm assuming it has something to do with how I am calling it from within the select().

TIA.

Andy (mod)
andy@ultranerds.co.uk

Aug 27, 2003, 4:27 AM

yogi

Veteran / Moderator (2199 posts)

Aug 27, 2003, 4:27 AM

Post #2 of 5

Shortcut

Re: [Andy] Using GT::SQL::Condition, and options in select? In reply to

I keep doing your homework (RTFM), but anyway:

Code:
my $cond = GT::SQL::Condition->new( 'Top_Order', '>', '0', 
                                    'isValidated',  '=', 'Yes',  
                                    'CategoryID', '=', $cat_id); 
$sth = $table->select($cond);

Ivan
-----
Iyengar Yoga Resources / GT Plugins

Aug 27, 2003, 4:40 AM

Andy

Veteran / Moderator (18441 posts)

Aug 27, 2003, 4:40 AM

Post #3 of 5

Shortcut

Re: [yogi] Using GT::SQL::Condition, and options in select? In reply to

So you have to do everything in GT::SQL::Condition? Seems a bit silly.. surely that just makes more work,out of a couple of simple statements, and one advanced one? BTW, does this support the calling of several tables? (lsql_Links lsql_Category and lsql_CatLinks) ?

Cheers

Andy (mod)
andy@ultranerds.co.uk

Aug 27, 2003, 4:54 AM

Andy

Veteran / Moderator (18441 posts)

Aug 27, 2003, 4:54 AM

Post #4 of 5

Shortcut

Re: [Andy] Using GT::SQL::Condition, and options in select? In reply to

Just tried it, and it doesn't seem to work Unsure

Cheers

Andy (mod)
andy@ultranerds.co.uk

Aug 27, 2003, 6:56 AM

Andy

Veteran / Moderator (18441 posts)

Aug 27, 2003, 6:56 AM

Post #5 of 5

Shortcut

Re: [Andy] Using GT::SQL::Condition, and options in select? In reply to

This seems to work.. very odd... Laugh

Code:
$sth = $table->select( { isValidated => 'Yes' }, { CategoryID => $cat_id }, GT::SQL::Condition->new( 'Top_Order', '>', '0' ) );

Cheers

Andy (mod)
andy@ultranerds.co.uk