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:
Ports? (2002)
[WebDNA] GREP Question (2009)
Generating unique SKU from [cart] - Still Stumped... (1997)
tcpconnect/tcpsend frustrations (2002)
Active Server Code... (1998)
Verifying both name and password (was: New Problem) (1997)
can WC render sites out? (1997)
Encrypting the seed (2001)
Pulling Captions from JPGs (2003)
PCS Frames (1997)
?The parameter is incorrect.? (2006)
PhotoMill -> PhotoMaster (1997)
Extended [ConvertChars] (1997)
[SHOWIF AND/OR] (1997)
When to Commitdatabase? (2004)
[WebDNA] WebDNA code validator (2011)
SSL with IIS 4.0 (1998)
OK, here goes... (1997)
Can't load tmpl files (1997)
Email...Thanks (1997)