Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Select price ranges?

Quote Reply
Select price ranges?
Hi,

I'd like to select records based on ranges for the field PRICE, i.e.; 0-499, 500-999, 1000-2999, etc.

I know its a case of 'gt' lower price AND 'lt' higher price, but how do I add that to the db.cgi URL?

Any assistance appreciated


All the best
Shaun
Quote Reply
Re: [qango] Select price ranges? In reply to
Just simply like:

db.cgi?db=table;price-lt=1000;price-gt=100

or

db.cgi?db=table;price-le=1000;price-ge=100

TheStone.

B.
Quote Reply
Re: [TheStone] Select price ranges? In reply to
Stone,

Thanks - that looks nice and simple. If only everything was that easy ... Smile


All the best
Shaun