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:

    
  1. Re: SEARCH DATE RANGE (Kenneth Grome 2000)
  2. SEARCH DATE RANGE (Robert Kudrle 2000)
  3. Re: SEARCH DATE RANGE (Conley Hanson 2000)
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 > >
> > [url]STARTDATE[/url] size=12> > > [url]ENDDATE[/url] size=12> > >
>
> > 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)