Re: date search not working when type=date specified
This WebDNA talk-list message is from 2007
It keeps the original formatting.
numero = 69188
interpreted = N
texte = What does this do for you?[search db=db/leads.db&eqREP_IDdatarq=0[!][/!]&rnLEAD_DATEdatarq=4/1/2006 4/31/2006[!][/!]&deLEAD_RANKsort=1[!][/!]&asLEAD_DATEsort=2[!][/!]&asLEAD_NAMEsort=3[!][/!]&REP_IDtype=num[!][/!]&LEAD_DATEtype=date]GJKAt 11:26 PM 7/23/2007, you 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=dat e]>>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/
Associated Messages, from the most recent to the oldest:
What does this do for you?[search db=db/leads.db&eqREP_IDdatarq=0[!][/!]&rnLEAD_DATEdatarq=4/1/2006 4/31/2006[!][/!]&deLEAD_RANKsort=1[!][/!]&asLEAD_DATEsort=2[!][/!]&asLEAD_NAMEsort=3[!][/!]&REP_IDtype=num[!][/!]&LEAD_DATEtype=date]GJKAt 11:26 PM 7/23/2007, you 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=dat e]>>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/
Gary Krockover
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:
Major Security Hole IIS NT (1998)
Reserved word? (2005)
Overridding E-Mailer (1998)
I give up!! (1997)
WebDNA Programmer addendum (2004)
A question on sub-categories (1997)
FORM NONSENSE - WAS: How much is too much? (2002)
[OT] Trying to steal databases on our server (2003)
Resume Catalog ? (1997)
return missing item (was:WebCat Sales) (1997)
[WebDNA] Bullet proof dynamic tables (2009)
bug in [SendMail] (1997)
Photo Album (2000)
emailer (1997)
RE: Displaying Location (1997)
b12 cannot limit records returned and more. (1997)
email server and webdna (2006)
Batch printing of web pages (2003)
WebCat2 Append problem (B14Macacgi) (1997)
do you have a webcatalog tool you want to sell? (1999)