Help with searching dates from mysql dump & searching between
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 68100
interpreted = N
texte = Aloha all, Am having some trouble searching date fields from a mysql data dump. The dump I get is in the following format (in one field): "2006-11-03 21:43:22" Sorting doesn't work. Also get weird results from searching these fields. Do I have to write a script to split this into two fields? Also, any advice on how to search for records that are between two dates? I have two dates in the table in the above format so I tried the following: [search db=EVENT.db&leEND_DATEdatarq=[year]-[pickMonth]-[index]&geCREATE_DATEdatarq= [year]-[pickMonth]-[index]&CREATE_DATEtype=date&END_DATEtype=date] I want to get for all that for a given day are AFTER a create date but BEFORE an end date. Tried a bunch of stuff that hasn't worked, again on the above "date/time in one field" format. Any advice would be greatly appreciated! Thanks, 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:
Aloha all, Am having some trouble searching date fields from a mysql data dump. The dump I get is in the following format (in one field): "2006-11-03 21:43:22" Sorting doesn't work. Also get weird results from searching these fields. Do I have to write a script to split this into two fields? Also, any advice on how to search for records that are between two dates? I have two dates in the table in the above format so I tried the following: [search db=EVENT.db&leEND_DATEdatarq=[year]-[pickMonth]-[index]&geCREATE_DATEdatarq= [year]-[pickMonth]-[index]&CREATE_DATEtype=date&END_DATEtype=date] I want to get for all that for a given day are AFTER a create date but BEFORE an end date. Tried a bunch of stuff that hasn't worked, again on the above "date/time in one field" format. Any advice would be greatly appreciated! Thanks, 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/
"Olin Lagon"
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:
ShowNext (1997)
WebCatalog Use Question (1997)
Showif, Hideif reverse logic ? (1997)
retail and wholesale... (2000)
Re2: frames & carts (1997)
[WebDNA] Major grep/convertchars linux issues when writing to db (2010)
Part Html part WebDNA (1997)
default error on NT? (1997)
Document Contains No Data! (1997)
Double Spacing in Mails from Sendmail (2002)
Success Stories (1997)
Webstar 1.3.1 PPC (1997)
Fedora Core 6 (2007)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
[append] problems (2003)
send people in a database an email (2001)
Bug or syntax error on my part? (1997)
Database wiped clean (2005)
question: back button prevention (1997)
A Global Variable (1997)