Gossamer Forum
Quote Reply
Less than, but not more?
Is there a way to do a less than or equal comparison in searches? I've tried;

search.cgi?query=&Age=>18&Age=<20

but that doesn't seem to work. Has anyone had this working?

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Less than, but not more? In reply to
Anyone? Unsure

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Less than, but not more? In reply to
search.cgi?Age-lt=18&Age-gt=20

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Less than, but not more? In reply to
Don't you have that back to front?
Quote Reply
Re: [Paul] Less than, but not more? In reply to
Probably. =)

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Less than, but not more? In reply to
Hi Alex...does that accommidate 'less than, but equal' and 'greater than, but equal' ? Unsure

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Less than, but not more? In reply to
*bump*

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Less than, but not more? In reply to
I've just had a peek in admin/Links/User/Search.pm, and it doesn't seem like your engine supports lt or equlr (and greater than or equal)....do you have any hacks that would allow this feature to be added?

Thanks in advance.

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Less than, but not more? In reply to
Just reduce one number by one and increase the other by one Crazy

greater than 15 and less than 20

...is the same as:

greater than or equal to 16 and less than or equal to 19
Quote Reply
Re: [Paul] Less than, but not more? In reply to
Wow...interesting idea. Thanks Paul...Smile

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Less than, but not more? In reply to
You can use:

# field_name => value # Find all rows with field_name = value
# field_name => ">value" # Find all rows with field_name > value.
# field_name => "<value" # Find all rows with field_name < value.
# field_name-gt => value # Find all rows with field_name > value.
# field_name-lt => value # Find all rows with field_name < value.
# field_name-ge => value # Find all rows with field_name >= value.
# field_name-le => value # Find all rows with field_name <= value.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Less than, but not more? In reply to
Thanks for the reply Alex. I managed to get around it with Pauls idea... Smile

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!