Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Development, Plugins and Globals :

How to say it with xxx=> 'yes'

Jul 24, 2003, 10:17 AM
Robert
Enthusiast (901 posts)
Robert's avatar
Jul 24, 2003, 10:17 AM
Post #1 of 4
Views: 2176
Shortcut
Quote Reply
How to say it with xxx=> 'yes'
Very often i found something like this in lsql:

my $count = $cat_link->count ( { CategoryID => $root_id, isValidated => 'Yes'} );

Mots of time it is used as a query for mysql,
meaning e.g. isValidated => 'Yes' ~~~ where isValideted = 'Yes',

For some reasons i need not only an equal, i need >,< or =!
I tried it with 'isValidated','!=','No' (the same to eq, but it dont fix my problem.

Any ideas?
Jul 24, 2003, 2:01 PM
Paul
Veteran (19537 posts)
Jul 24, 2003, 2:01 PM
Post #2 of 4
Views: 2137
Shortcut
Quote Reply
Re: [Robert] How to say it with xxx=> 'yes' In reply to
Use GT::SQL::Condition

I've moved this post into the Links SQL forum.
Jul 24, 2003, 6:17 PM
webslicer
User (236 posts)
Jul 24, 2003, 6:17 PM
Post #3 of 4
Views: 2108
Shortcut
Quote Reply
Re: [Paul] How to say it with xxx=> 'yes' In reply to
Could you give an example, Paul?
Jul 24, 2003, 7:13 PM
Robert
Enthusiast (901 posts)
Robert's avatar
Jul 24, 2003, 7:13 PM
Post #4 of 4
Views: 2103
Shortcut
Quote Reply
Re: [Robert] How to say it with xxx=> 'yes' In reply to
Yes, just remember it. Here the new part:
Code:
my $root_total = $cat_link->count(GT::SQL::Condition->new ('CategoryID', '=', $cat_id,
'isValidated', '=', 'Yes',
'Stern', '<>', '0')
);

from the old one:
Code:
my $root_total = $cat_link->count(
CategoryID => $cat_id,
isValidated => 'Yes');


In the first example i could use an <> while with hashes i think i could only use the =


I really love lsql and maybe show you soon why, smile ;-)