Re: date search not working when type=date specified

This WebDNA talk-list message is from

2007


It keeps the original formatting.
numero = 69190
interpreted = N
texte = I always store dates as numbers. It's much easier to handle ... mydate=[math]{[date]}[/math] Perhaps it's to late for you to change them, but if you build from scratch, I'd use numbers ... Thierry Stuart Tremain schrieb: > The answer to your problem is probably due to the dates not formatted in > mm/dd/yyy ie no leading zeros > > 04/01/2007 > & > 04/31/2007 > > > > On 24 Jul 2007, at 2:26 PM, Charles Kline wrote: > >> Hey all. >> >> Got a weird date search problem: >> >> [search db=db/leads.db&eqREP_IDdatarq=0&rnLEAD_DATEdatarq=4/1/2006 >> 4/31/2006&LEAD_RANKsort=1&LEAD_RANKsdir=de&LEAD_DATEsort=2&LEAD_DATEsdir=as&LEAD_NAMEsort=3&LEAD_NAMEsdir=as&LEAD_RANKtype=num&LEAD_DATEtype=date] >> >> >> Does NOT return any records. (it should) >> >> [search db=db/leads.db&eqREP_IDdatarq=0&rnLEAD_DATEdatarq=4/1/2006 >> 4/31/2006&LEAD_RANKsort=1&LEAD_RANKsdir=de&LEAD_DATEsort=2&LEAD_DATEsdir=as&LEAD_NAMEsort=3&LEAD_NAMEsdir=as&LEAD_RANKtype=num] >> >> >> Does return the requested records, in the proper date range, but the >> sort does not work (due to the fact it is missing LEAD_DATEtype=date). >> >> Any ideas? >> >> - Charles >> >> ------------------------------------------------------------- >> 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 >> >> Web Archive of this list is at: http://webdna.smithmicro.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 > > Web Archive of this list is at: http://webdna.smithmicro.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 Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: date search not working when type=date specified ( Charles Kline 2007)
  2. Re: date search not working when type=date specified ( Charles Kline 2007)
  3. Re: date search not working when type=date specified ( Charles Kline 2007)
  4. Re: date search not working when type=date specified ( Terry Wilson 2007)
  5. Re: date search not working when type=date specified ( Chris 2007)
  6. Re: date search not working when type=date specified ( thierry 2007)
  7. Re: date search not working when type=date specified ( Stuart Tremain 2007)
  8. Re: date search not working when type=date specified ( Gary Krockover 2007)
  9. Re: date search not working when type=date specified ( Donovan Brooke 2007)
  10. Re: date search not working when type=date specified ( Stuart Tremain 2007)
  11. date search not working when type=date specified ( Charles Kline 2007)
I always store dates as numbers. It's much easier to handle ... mydate=[math]{[date]}[/math] Perhaps it's to late for you to change them, but if you build from scratch, I'd use numbers ... Thierry Stuart Tremain schrieb: > The answer to your problem is probably due to the dates not formatted in > mm/dd/yyy ie no leading zeros > > 04/01/2007 > & > 04/31/2007 > > > > On 24 Jul 2007, at 2:26 PM, Charles Kline wrote: > >> Hey all. >> >> Got a weird date search problem: >> >> [search db=db/leads.db&eqREP_IDdatarq=0&rnLEAD_DATEdatarq=4/1/2006 >> 4/31/2006&LEAD_RANKsort=1&LEAD_RANKsdir=de&LEAD_DATEsort=2&LEAD_DATEsdir=as&LEAD_NAMEsort=3&LEAD_NAMEsdir=as&LEAD_RANKtype=num&LEAD_DATEtype=date] >> >> >> Does NOT return any records. (it should) >> >> [search db=db/leads.db&eqREP_IDdatarq=0&rnLEAD_DATEdatarq=4/1/2006 >> 4/31/2006&LEAD_RANKsort=1&LEAD_RANKsdir=de&LEAD_DATEsort=2&LEAD_DATEsdir=as&LEAD_NAMEsort=3&LEAD_NAMEsdir=as&LEAD_RANKtype=num] >> >> >> Does return the requested records, in the proper date range, but the >> sort does not work (due to the fact it is missing LEAD_DATEtype=date). >> >> Any ideas? >> >> - Charles >> >> ------------------------------------------------------------- >> 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 >> >> Web Archive of this list is at: http://webdna.smithmicro.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 > > Web Archive of this list is at: http://webdna.smithmicro.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 Web Archive of this list is at: http://webdna.smithmicro.com/ thierry

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:

Requiring that certain fields be completed (1997) WC TableGrinder (1997) [WebDNA] Hmmm ... (2008) Webstar 1.3.1 PPC (1997) [authenticate] (1999) [WebDNA] WebDNA Crashing or Not **YES** (2008) Secure server question (1997) [Sum] function? (1997) Anyone selling 4.5 NT License? (2003) Interface to Quickbooks (2005) Summary layout (1997) Weird Math and SV (1997) TIP OF THE DAY (2004) details (2003) Searching multiple Databases (1997) Support ?? (1997) Plugin or CGI or both (1997) Help! WebCat2 bug (1997) [OT] Conversion from QuickMail Pro (2002) wc 2 pro users - sites, quotes wanted (1997)