Gossamer Forum
Home : Products : DBMan : Customization :

range search not lt/gt but le/ge?

Quote Reply
range search not lt/gt but le/ge?
Hi again,

perhaps anybody knows how to work this out:

I like to do a range search, but not only with with > < , what i need is <= or/and >=

I read that the html-code will work with '-le or -ge', but I thing dbman needs a modifikation in perl-code of the range-search. thank you for your help,

bek

------------------
Quote Reply
Re: range search not lt/gt but le/ge? In reply to
bek,

At this time, DBMAN does not allow true AND/OR searches for any fields or types of search, including range searches.

Gossamer Threads is working on the next release of DBMAN and one of the things I hope they will include in the next release is Boolean (AND/OR) searches.

Regards,

------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us
Quote Reply
Re: range search not lt/gt but le/ge? In reply to
Thanks a lot Eliot,

i hoped it could be possible...

thank you again for your answering.
bytheway:
i solved my "checkbox-problem" in a "third" way: a field with three options 'm(ale),f(emale),m&f'. The search for one gender will answer the "mixed" records,too - searching for "mixed" will only display that records.

Thank you for you tips again,

bek

------------------
Quote Reply
Re: range search not lt/gt but le/ge? In reply to
Glad you figured it out.

Regards,

------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us
Quote Reply
Re: range search not lt/gt but le/ge? In reply to
Hi,
Carol figured this out for me a while ago. She told me to 'trick' DBMan a littlebit.

Put the following code in your 'sub query' in the script, replace the 'fieldname' with the name of the field, the searching is about.
Code:
if ($in{'fieldname-gt'}) {
--$in{'fieldname-gt'};
}
if ($in{'fieldname-lt'}) {
++$in{'fieldname-lt'};
}
This will do.
Quote Reply
Re: range search not lt/gt but le/ge? In reply to
Just under

"local (%sortby);"

OK???
Quote Reply
Re: range search not lt/gt but le/ge? In reply to
Thanks a lot it's working fine,

bek
Quote Reply
Re: range search not lt/gt but le/ge? In reply to
Thank you mart,

but where at sub query should i put in?

There are any "extra tips"?

Thank you, very much

bek