Gossamer Forum: Products: Gossamer Links: Discussions: category Depth 1 or 2

Sep 21, 2007, 5:45 AM

Dorette

User (162 posts)

Sep 21, 2007, 5:45 AM

Post #1 of 12

Shortcut

category Depth 1 or 2

IO have a global that is picking up links for my home page.
It is currently set to pick up links with CatDepth => 1,
I want it to pick up for all Category depths except 0, that is 1, 2, 3 and as much as i will have later on .

this is how it looks now,

my $sth = $tbl->select( { CatDepth => 1 } ) || die $GT::SQL::error;

I tried

my $sth = $tbl->select( { CatDepth => 2 } ) || die $GT::SQL::error;

and will only pick up categories with depth 2

can any one help me

Sep 22, 2007, 3:02 AM

Andy

Veteran / Moderator (18441 posts)

Sep 22, 2007, 3:02 AM

Post #2 of 12

Shortcut

Re: [Dorette] category Depth 1 or 2 In reply to

Hi,

Try this:

Code:
my $sth = $tbl->select( GT::SQL::Condition->new('CatDepth','>','2') )  || die $GT::SQL::error;

Hope that helps.

Andy (mod)
andy@ultranerds.co.uk

Sep 22, 2007, 6:35 AM

Dorette

User (162 posts)

Sep 22, 2007, 6:35 AM

Post #3 of 12

Shortcut

Re: [Andy] category Depth 1 or 2 In reply to

Sorry Andy
it is not picking up any links at all.

Last edited by:

Dorette: Sep 22, 2007, 6:38 AM

Sep 22, 2007, 2:52 PM

Andy

Veteran / Moderator (18441 posts)

Sep 22, 2007, 2:52 PM

Post #4 of 12

Shortcut

Re: [Dorette] category Depth 1 or 2 In reply to

Hi,

Try:

Code:
$sth = $tbl->select( GT::SQL::Condition->new('CatDepth','>=','2') ) || die $GT::SQL::error:;

Cheers

Andy (mod)
andy@ultranerds.co.uk

Sep 22, 2007, 10:44 PM

Dorette

User (162 posts)

Sep 22, 2007, 10:44 PM

Post #5 of 12

Shortcut

Re: [Andy] category Depth 1 or 2 In reply to

Thanks Andy,
i tried and it is listing only links with cat depth 2 no more ones with cat depth1

Sep 23, 2007, 2:17 AM

Andy

Veteran / Moderator (18441 posts)

Sep 23, 2007, 2:17 AM

Post #6 of 12

Shortcut

Re: [Dorette] category Depth 1 or 2 In reply to

Hi,

Just try this then ;

Code:
$sth = $tbl->select( GT::SQL::Condition->new('CatDepth','>','0') ) || die $GT::SQL::error;

All you need to do was edit the > bit :P

Cheers

Andy (mod)
andy@ultranerds.co.uk

Last edited by:

Andy: Sep 23, 2007, 3:30 AM

Sep 23, 2007, 2:32 AM

Wychwood

User (182 posts)

Sep 23, 2007, 2:32 AM

Post #7 of 12

Shortcut

Re: [Andy] category Depth 1 or 2 In reply to

Might need to remove the colon infront of the semicolon though Cool

Sep 23, 2007, 3:31 AM

Andy

Veteran / Moderator (18441 posts)

Sep 23, 2007, 3:31 AM

Post #8 of 12

Shortcut

Re: [Wychwood] category Depth 1 or 2 In reply to

Well spotted =) (I wrote that code after hitting my middle finger with a hammer last weekend, so was a bit careful how I typed :D)

Cheers

Andy (mod)
andy@ultranerds.co.uk

Sep 23, 2007, 7:28 AM

Dorette

User (162 posts)

Sep 23, 2007, 7:28 AM

Post #9 of 12

Shortcut

Re: [Andy] category Depth 1 or 2 In reply to

hi Wychwood,
thanks, I did take it off but did not work

Andy
I figured out how to make it work later on

my $sth = $tbl->select( GT::SQL::Condition->new('CatDepth','<=','2') ) || die $GT::SQL::error;

Sep 24, 2007, 1:36 AM

Andy

Veteran / Moderator (18441 posts)

Sep 24, 2007, 1:36 AM

Post #10 of 12

Shortcut

Re: [Dorette] category Depth 1 or 2 In reply to

Hi,

Quote:

my $sth = $tbl->select( GT::SQL::Condition->new('CatDepth','<=','2') ) || die $GT::SQL::error;

Erm, but that will get CatDepth LESS THAN or EQUAL to 2 ? (I thought you said you didn't want to get CatDepth=0 ?)

Cheers

Andy (mod)
andy@ultranerds.co.uk

Sep 24, 2007, 6:52 AM

Dorette

User (162 posts)

Sep 24, 2007, 6:52 AM

Post #11 of 12

Shortcut

Re: [Andy] category Depth 1 or 2 In reply to

Quote:

I want it to pick up for all Category depths except 0, that is 1, 2, 3 and as much as i will have later on .

No Andy,
I wanted 1 and up
Thank you
Dorette

Sep 25, 2007, 1:45 AM

Andy

Veteran / Moderator (18441 posts)

Sep 25, 2007, 1:45 AM

Post #12 of 12

Shortcut

Re: [Dorette] category Depth 1 or 2 In reply to

Well, in that case, this won't work ;)

Code:
my $sth = $tbl->select( GT::SQL::Condition->new('CatDepth','<=','2') ) || die $GT::SQL::error;

..You need:

Code:
my $sth = $tbl->select( GT::SQL::Condition->new('CatDepth','>','0') ) || die $GT::SQL::error;

Cheers

Andy (mod)
andy@ultranerds.co.uk