Re: SEARCH DATE RANGE
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 28613
interpreted = N
texte = Make sure you are defining you field types as dates in your search. DATEtype=date&GROUP2type=dateRobert Kudrle wrote:> I've looked at the examples from provided from the Talk list regarding this similar issue but haven't correct results.>> Trying to do a search in our orders.db for a specific range of date. But their is something wrong with this code. You John Hill mentioned in the Talk List that you can't have two different comparison operators working on the same field name. So I created Groups like he suggested, but but the returned date ranges are scattered.>> MY FORM>>
>> RESULTS PAGE>> [search db=../orders.db&geDATEdatarq=[URL][STARTDATE][/URL]&GROUP2field=DATE&leGROUP2datarq=[URL][ENDDATE][/URL]&DATEsort=1&DATEsdir=de&max=[_max]]>> Very greatful to anyone who can shine some light on this.>> Thanks,>> --> Robert Kudrle> Coil, Counts, Ford & Cheney> 150 East Huron, Suite 1250> Chicago, Illinois 60611> phone:(312) 640-3509> fax: (312) 649-6316> rjk27@ccfc.com>> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list
.> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to -------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
Make sure you are defining you field types as dates in your search. DATEtype=date&GROUP2type=dateRobert Kudrle wrote:> I've looked at the examples from provided from the Talk List regarding this similar issue but haven't correct results.>> Trying to do a search in our orders.db for a specific range of date. But their is something wrong with this code. You John Hill mentioned in the Talk List that you can't have two different comparison operators working on the same field name. So I created Groups like he suggested, but but the returned date ranges are scattered.>> MY FORM>> >> RESULTS PAGE>> [search db=../orders.db&geDATEdatarq=[url][STARTDATE][/URL]&GROUP2field=DATE&leGROUP2datarq=[url][ENDDATE][/URL]&DATEsort=1&DATEsdir=de&max=[_max]]>> Very greatful to anyone who can shine some light on this.>> Thanks,>> --> Robert Kudrle> Coil, Counts, Ford & Cheney> 150 East Huron, Suite 1250> Chicago, Illinois 60611> phone:(312) 640-3509> fax: (312) 649-6316> rjk27@ccfc.com>> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to -------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Conley Hanson
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
PIXO Support (1997)
[WebDNA] Math Precision Preshmilson (2019)
shipcost (1997)
Odd Cart Behavior (1997)
Problems getting parameters passed into email. (1997)
[WebDNA] webdna.us (2008)
format_to_days on NT (1997)
M$loth messes with our sites (again) 2004/02/03 (2004)
ANNC: MerchantMaker releases SuperCatalog v2.1 (2000)
unable to launch acgi in WebCat (1997)
Error & Problem (1997)
TEXT Variable (2003)
WebCat2b12 - New features for 1.6 users ... (1997)
ExclusiveLock (2000)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Order not created error (1997)
RE: type 2 errors with ssl server (1997)
Quit revisited (1997)
[OT] Who's got a cool link (2002)
hiding links (1999)