Re: date search not working when type=date specified
This WebDNA talk-list message is from 2007
It keeps the original formatting.
numero = 69195
interpreted = N
texte = Will give it a shot. I think I had them this way to start and just removed the leading 0 in an effort to figure it out.. it was getting late though. I will take all the suggestions into account and take another look today.- CharlesOn Jul 24, 2007, at 8:15 AM, Terry Wilson wrote:> 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 work>> Terry>>> 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_DATEs >> dir=as&LEAD_NAMEsort=3&LEAD_NAMEsdir=as&LEAD_RANKtype=num&LEAD_DATEty >> pe=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_DATEs >> dir=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.com> http://WhosComing.com - a simplified, affordable online reservation > system> http://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 digest@talk.smithmicro.com>> 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:
Will give it a shot. I think I had them this way to start and just removed the leading 0 in an effort to figure it out.. it was getting late though. I will take all the suggestions into account and take another look today.- CharlesOn Jul 24, 2007, at 8:15 AM, Terry Wilson wrote:> 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 work>> Terry>>> 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_DATEs >> dir=as&LEAD_NAMEsort=3&LEAD_NAMEsdir=as&LEAD_RANKtype=num&LEAD_DATEty >> pe=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_DATEs >> dir=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.com> http://WhosComing.com - a simplified, affordable online reservation > system> http://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 digest@talk.smithmicro.com>> 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/
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:
DD/MM/YY reseting (1999)
Code ideas req: Matrix of users and options [code] (2003)
[BoldWords] WebCat.acgib15Mac (1997)
search context w shownext works! (1997)
WebCat2.0b15-to many nested [xx] tags (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
RE: Adding headers to email (1997)
Looking up two prices in database? (1997)
writefile to create static pages (2003)
WebCat2 - [format thousands] (1997)
ups shipping based on weight (1999)
More on the email templates (I like it) (1997)
Bug or syntax error on my part? (1997)
Re:Problem displaying search result (1997)
[OT] Indexing of dynamic web sites (2003)
listdatabases,flushdatabases browser problem not webcat (2000)
For you Unix gurus [OT] (2002)
emptying shopping carts and orders folder (2004)
Follow-Up to: Removing [showif] makes a big difference in speed (1997)
New public beta available (1997)