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:

[WebDNA] Authorize working connection... (2019) Not really WebCat (1997) New Web Site Developers Database (1996) [referrer] -truncates at & (1998) Pithy questions on webcommerce & siteedit (1997) [WebDNA] Off topic: ImageMagick (2008) [NT] ie 4.0 required (1997) users.db (1999) [OT] Startin' sumthin' again - Python, anyone tried it? (2006) How To question on setting up downloads (1997) WebCatalog can't find database (1997) Bannerad Demo (1998) Re1000001: Setting up shop (1997) WebCatalog can't find database (1997) sendmail tag when with in comment tags. (2000) WC2b15 File Corruption (1997) Unix Timestamp using WebDNA [code req] (2003) RequiredFields template (1997) RE: [WebDNA] XML Help (2009) Multiple Sendmail Tags on One Page (2008)