Gossamer Forum
Home : Products : DBMan : Customization :

Re: [peterhall] range search syntax

Quote Reply
Re: [peterhall] range search syntax In reply to
I'm not sure what the $config hash is for. It doesn't mean anything in DBMan, but maybe you've merged DBMan with something else. In general, if you want to search for something that is "less than" or "greater than" use fieldname-lt for "less than" and fieldname-gt for "greater than." So, if you have a field that's called "height" and you want to find all people who are between 58 inches tall and 63 inches tall, inclusive, you would have two fields:

name="height-lt" value=64
name="height-gt" value=57

I"m not sure how that would relate to your application, but maybe this'll help. :-)

Regarding the URL hyperlink, you have to tell DBMan to do that. If you're using the autogenerate feature in DBMan, you might want to consider using the mod I wrote, called "Autogenerate Enhancements." It's at http://www.jpdeni.com/...ods/autogenerate.txt . If you apply that mod, the script will automatically make clickable links when either a URL or an email address is being displayed. The URL only works if it starts with http://.


JPD
----------------------------------------------------
JPDeni's DBMan-ual
How to ask questions the smart way.
Subject Author Views Date
Thread range search syntax peterhall 11718 Dec 26, 2005, 8:32 PM
Thread Re: [peterhall] range search syntax
JPDeni 11499 Dec 27, 2005, 4:25 AM
Thread Re: [JPDeni] range search syntax
peterhall 11499 Dec 27, 2005, 5:24 AM
Thread Re: [peterhall] range search syntax
JPDeni 11478 Dec 27, 2005, 6:11 AM
Thread Re: [JPDeni] range search syntax
peterhall 11476 Dec 27, 2005, 4:47 PM
Thread Re: [peterhall] range search syntax
JPDeni 11452 Dec 28, 2005, 5:27 AM
Post Re: [JPDeni] range search syntax
peterhall 11427 Dec 28, 2005, 7:40 PM