Re: Help with searching dates from mysql dump & searching

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 68101
interpreted = N
texte = Your raw date field is already a canonically-sortable string, so it doesn't need to be converted to a date type. Remove the &CREATE_DATEtype=date&END_DATEtype=date in order to make WebDNA interpret those fields as plain text. > [search > db=EVENT.db&leEND_DATEdatarq=[year]-[pickMonth]-[index]&geCREATE_DATEdatarq= > [year]-[pickMonth]-[index]&CREATE_DATEtype=date&END_DATEtype=date] > ------------------------------------------------------------- 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:

    
  1. Re: Help with searching dates from mysql dump & searching ( "Olin Lagon" 2006)
  2. Re: Help with searching dates from mysql dump & searching ( Gary Krockover 2006)
  3. Re: Help with searching dates from mysql dump & searching ( "Olin Lagon" 2006)
  4. Re: Help with searching dates from mysql dump & searching ( Gary Krockover 2006)
  5. Re: Help with searching dates from mysql dump & searching ( Gary Krockover 2006)
  6. Re: Help with searching dates from mysql dump & searching ( "Olin Lagon" 2006)
  7. Re: Help with searching dates from mysql dump & searching ( Grant Hulbert 2006)
  8. Help with searching dates from mysql dump & searching between ( "Olin Lagon" 2006)
Your raw date field is already a canonically-sortable string, so it doesn't need to be converted to a date type. Remove the &CREATE_DATEtype=date&END_DATEtype=date in order to make WebDNA interpret those fields as plain text. > [search > db=EVENT.db&leEND_DATEdatarq=[year]-[pickMonth]-[index]&geCREATE_DATEdatarq= > [year]-[pickMonth]-[index]&CREATE_DATEtype=date&END_DATEtype=date] > ------------------------------------------------------------- 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/ Grant Hulbert

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:

WebCatalog for guestbook ? (1997) [WebDNA] Installation problems for IIS 6 (2010) Tracking System? (1997) Running _every_ page through WebCat-error.html (1997) emailer (1997) Summing fields (1997) PCS Frames (1997) PCS Emailer's role ? (1997) PCS Emailer's role ? (1997) [format] (1998) Need relative path explanation (1997) Almost a there but..bye bye NetCloak (1997) NewCart+Search with one click ? (1997) [WebDNA] Test - new subject (2019) Cross OS Compatible HTML emailing (2003) Just Started (1998) Redirect (2003) PCS Frames (1997) [Fwd: Rotating Banners ... (was LinkExchange)] (1997) File Upload (1997)