Re: Help with searching dates from mysql dump & searching
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 68103
interpreted = N
texte = That's because as you have it now, it's a text string so there is nothing for it to be equal or not equal too. If you're using European style dates in the WebDNA config, here's what I would do: Run a [listwords] on the log using the space as the separator. Append that to a new table (or temp db) with 3 fields, SKU, DATESTAMP and TIMESTAMP (the listwords will seperate those last two). Then you can search the table (temp.db) using normal date search procedures. I'd recommend a "Range" search: [search db=TEMP.db&neSKUdatarq=[blank]&rnDATESTAMPdata={low end date} {high end date}&sort=...etc] GJK At 05:41 PM 11/5/2006, you wrote: >Thanks Grant! Been a loooong time. > >The sorting works fine now. The searching partly. This works > >[...&geCREATE_DATEdatarq=[eventStartDate]...] > >It finds records in the DB that are greater than or equal to the >eventStartDate. However, when I add the following to create an upper limit, >I get no search results: > >[...&geCREATE_DATEdatarq=[eventStartDate]&leEND_DATEdatarq=[eventEndDate]... >] > >And this also produces no results (taking out the first date search >parameter) > >[...&leEND_DATEdatarq=[eventEndDate]...] > >So, it seems that I can't get a less than or equal to an end date. Is this >because the data in the field has both a date and time? > >Also tried to manually put in dummy time data >([...&leEND_DATEdatarq=[eventEndDate] 00:00:00&...]) which didn't work. > >Mahalo, Olin ------------------------------------------------------------- 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:
That's because as you have it now, it's a text string so there is nothing for it to be equal or not equal too. If you're using European style dates in the WebDNA config, here's what I would do: Run a [listwords] on the log using the space as the separator. Append that to a new table (or temp db) with 3 fields, SKU, DATESTAMP and TIMESTAMP (the listwords will seperate those last two). Then you can search the table (temp.db) using normal date search procedures. I'd recommend a "Range" search: [search db=TEMP.db&neSKUdatarq=[blank]&rnDATESTAMPdata={low end date} {high end date}&sort=...etc] GJK At 05:41 PM 11/5/2006, you wrote: >Thanks Grant! Been a loooong time. > >The sorting works fine now. The searching partly. This works > >[...&geCREATE_DATEdatarq=[eventStartDate]...] > >It finds records in the DB that are greater than or equal to the >eventStartDate. However, when I add the following to create an upper limit, >I get no search results: > >[...&geCREATE_DATEdatarq=[eventStartDate]&leEND_DATEdatarq=[eventEndDate]... >] > >And this also produces no results (taking out the first date search >parameter) > >[...&leEND_DATEdatarq=[eventEndDate]...] > >So, it seems that I can't get a less than or equal to an end date. Is this >because the data in the field has both a date and time? > >Also tried to manually put in dummy time data >([...&leEND_DATEdatarq=[eventEndDate] 00:00:00&...]) which didn't work. > >Mahalo, Olin ------------------------------------------------------------- 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:
UPS QuickCost and More (2000)
ANother SHOWIF problem (1997)
Scratch & Win (1999)
Multiple Newcarts (1996)
Truncated Sendmail (1998)
possible, WebCat2.0 and checkboxes-restated (1997)
sort problems....bug or brain fart? (1997)
3.0 [TEXT] variables (1998)
date display (1999)
[ModDate] & [ModTime] ? (1997)
TCP Connect (2000)
orderfile stuff (1998)
2.01 upgrade problems (1997)
Strange errors in error log (1998)
2 databases (1998)
Country & Ship-to address & other fields ? (1997)
WebCat2: Found Items syntax, etc. (1997)
Site Test Please [OT] (2005)
Encrypt (1999)
Re:2nd WebCatalog2 Feature Request (1996)