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:
2nd WebCatalog2 Feature Request (1996)
fix permissions on osx ... (2004)
WebCat b15 Mac plug-in (1997)
[Shownext] [whynot] (2000)
embedded showif statements (2000)
Simple way to create unique SKU (1997)
security (1997)
shownext problems (1998)
writefile - continued (1997)
Generating unique SKU from [cart] (1997)
[Sum] function? (1997)
WebDelivery downloads alias, not original ? (1997)
Thanks ! (1997)
Generating unique SKU from [cart] - Still Stumped... (1997)
shipping madness (2000)
Max Record length restated as maybe bug (1997)
Nav. 4 probs with cart - Serious problem (1997)
searching for last file in a directory (1999)
Question from a Neebie (2000)
Shopping Cart Deletion (2000)