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:
Error: Can't open order file. Ignoring [OrderFile] context (2000)
[WebDNA] Lookup vs. Search (was: 3-5 GB of native WebDNA db...) (2009)
RE: OK, here goes... (1997)
WSDL Wizard (2003)
Problem (1997)
This list needs a digest: rant, rave... (1997)
Lookup within a Search (2005)
[WebDNA] WebDNA for Windows Newbie Questions (2008)
[WebDNA] Was there ever a BeOS compatible version? (2009)
Nested tags count question (1997)
Pixo support? (1998)
Stupid question (2003)
remotely add + sign (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
select multiple (1997)
Re:Emailer setup (1997)
carriage returns in data (1997)
Webcatalog 4.0 - When will we be able to beta test it? (2000)
[include ...] behavior (1997)
The & Problem (1998)