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:
Cookies and WebTV (1999)
Re2: frames & carts (1997)
[WebDNA] API- continued - bit.ly statistics (2011)
Server capacity (2003)
[WriteFile] problems (1997)
forms and variables (1998)
emailer (1997)
Reversed words (1997)
Running 2 two WebCatalog.acgi's (1996)
Configuring E-mail (1997)
Version f1 status (1997)
MacAuthorize Hub/Client and program linking (1997)
determining plug-ins? (1998)
Some Advise needed (1997)
Fwd: virtual domain and [listfile] paths and aliases (1998)
Another question (1997)
WebCat for mass emailings (1997)
HomePage Caution (1997)
shrink-wrapped version out yet? (1997)
Re:redirect from the errorsMessages.db entry (1997)