Re: date search not working when type=date specified
This WebDNA talk-list message is from 2007
It keeps the original formatting.
numero = 69194
interpreted = N
texte = I know this method... was actually how I had it first and tried the longer way to see if that was the problem... it wasn't :(On Jul 24, 2007, at 1:38 AM, Stuart Tremain wrote:> Charles>> Try writing your SORT info in another way:>>> &deLEAD_RANKsort=1> &asLEAD_DATEsort=2> &asLEAD_NAMEsort=3> &LEAD_DATEtype=date> &LEAD_RANKtype=num>> Obviously don't include the line breaks. Just a little shorter and > keeps things together. This method is undocumented but it does work :)>>> 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_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>>>> ------------------------------------------------------------->> 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 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:
I know this method... was actually how I had it first and tried the longer way to see if that was the problem... it wasn't :(On Jul 24, 2007, at 1:38 AM, Stuart Tremain wrote:> Charles>> Try writing your SORT info in another way:>>> &deLEAD_RANKsort=1> &asLEAD_DATEsort=2> &asLEAD_NAMEsort=3> &LEAD_DATEtype=date> &LEAD_RANKtype=num>> Obviously don't include the line breaks. Just a little shorter and > keeps things together. This method is undocumented but it does work :)>>> 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_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>>>> ------------------------------------------------------------->> 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 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:
Word Breaks (1998)
Formulas.db / Quantity Discount problem (1998)
multiple product databases (1997)
Trouble with formula.db + more explanation (1997)
Protecting webdelivery (1997)
Sense/Disallow HTML tags during $Append (1997)
select multiple (1997)
Change Subtotal (2000)
[table] strange behaviour (2003)
Buying sans cart (1997)
.html to .tpl (1998)
emailer and bad addresses (1997)
WebCat2: Items xx to xx shown, etc. (1997)
More on the email templates (1997)
Decimal/Modulus (2001)
math on date? (1997)
Not really WebCat (1997)
[isfile] ? (1997)
carriage returns in data (1997)
how does [middle] work? (1998)