Re: Help with searching dates from mysql dump & searching
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 68105
interpreted = N
texte = Forgot to add, autonumber the SKU, which is optional - but modify your search to neDATESTAMPdatarq=[blank] (probably best to just go ahead and do that). GJK At 06:52 PM 11/5/2006, you wrote: >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 ------------------------------------------------------------- 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:
Forgot to add, autonumber the SKU, which is optional - but modify your search to neDATESTAMPdatarq=[blank] (probably best to just go ahead and do that). GJK At 06:52 PM 11/5/2006, you wrote: >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 ------------------------------------------------------------- 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:
More DateMath problems (1997)
Help formatting search results w/ table (1997)
SERIAL NUMBER PROBLEM *AGAIN*!!! (1998)
Big Databases (1997)
[showif] with ! (2000)
Re:quit command on NT (1997)
Timeout question .. (2003)
Initiating NewCart (1997)
Tabled Discount (2003)
Authorize.net questions ... (2003)
FREE Web Server Monitor FREE (1997)
math problems (2000)
PSC recommends what date format yr 2000??? (1997)
problem serving foreign languages text (1997)
Friendly , quick 'security' check, please (2003)
Don't tick me off :) [elaspedtime] (1997)
How can I Add several Items into the cart at once? (1997)
a new bug? (1999)
Requiring that certain fields be completed (1997)
WebTen? (1997)