Re: date search not working when type=date specified
This WebDNA talk-list message is from 2007
It keeps the original formatting.
numero = 69192
interpreted = N
texte = Hi Charles... nice to see you are still on the list! Long time no see.About your dates... do this:04/01/2006 not 4/1/2006, and I bet it will workTerry>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-- Terry Wilson | terry@terryfic.com | http://terryfic.comhttp://WhosComing.com - a simplified, affordable online reservation systemhttp://TightJacket.com -- stylish protection for your laptop--------------------------------------------------------------------------Attitude is the only difference between ordeal and adventure.-------------------------------------------------------------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:
Hi Charles... nice to see you are still on the list! Long time no see.About your dates... do this:04/01/2006 not 4/1/2006, and I bet it will workTerry>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-- Terry Wilson | terry@terryfic.com | http://terryfic.comhttp://WhosComing.com - a simplified, affordable online reservation systemhttp://TightJacket.com -- stylish protection for your laptop--------------------------------------------------------------------------Attitude is the only difference between ordeal and adventure.-------------------------------------------------------------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/
Terry Wilson
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:
Re:[ShowIf] and empty fields (1997)
More than one db with the same namn (was: WC2f3) (1997)
[tcp connect] (1998)
[searchString] (1997)
Is there a max number of fields? (1998)
appleshare/ip (1997)
mail on NT (1998)
I'm having trouble using [url][interpret][math] together in lookup (1997)
[OT] SSL (2003)
WebCatalog Mac and cgi-bin (WebSTAR 2.0) (1997)
Limiting user access to .tmpl files (1997)
OK, here goes... (1997)
Changing the value assigned to a formvariable (2000)
Emailer setup (1997)
Search design (1997)
Alternative to Authorize.net (2002)
Lookups (2000)
HTTP Header / Meta Equiv (1999)
Log-in Scheme (2003)
WebCat2b12plugin - [search] is broken ... not! (1997)