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:
Enterprise Server (1998)
How to protect embedded images served via WebCatalog (2001)
A quickie question (1997)
No. of items in shopping cart (2000)
UPS Rate Tables (2002)
too many nested tags ... (1997)
Coding Standards - are there any ? (2003)
Server Speeds - a whole another world [OT] (2002)
Simple way to create unique SKU (1997)
Commas in search (1998)
Re:2nd WebCatalog2 Feature Request (1996)
Foreign Language [DATE] formats (2004)
RE: Languages (1997)
Multiple Merchant Accounts? (1997)
shipcost (1997)
Here is the code: (2000)
expired beta (1997)
[WebDNA] special chars (2009)
setting taxable to true (1997)
Bug or syntax error on my part? (1997)