date search not working when type=date specified
This WebDNA talk-list message is from 2007
It keeps the original formatting.
numero = 69185
interpreted = N
texte = 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:
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/
Charles Kline
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:
DNS Lookup 2 (2000)
Quit revisited (1997)
A quickie question (1997)
problems with 2 tags (1997)
summ=T (2003)
Internet Explorer 6 Form problems (2005)
You sent this to me by mistake. (1998)
Using EIMS instead of Emailer (1998)
Migrating to NT (1997)
Upgrading old WebCat Database Files (1997)
StoreBuilder help/question (2000)
sendmail spaces (1997)
Editor (2000)
Problems reading files created by WC (1997)
(2000)
Fufillment e-mail? (1998)
affiliate marketing program (1998)
Frames and WebCat (1997)
Working HTML email (2001)
[SearchString] usage (1997)