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:

Locking up with WebCatalog... (1997) Help with getting rpm file (2002) Decrypting a user password (2000) PROBLEM (1997) Email Attachments (1998) Giving out error pages (1997) WebCat2 beta 11 - new prefs ... (1997) Running 2 two WebCatalog.acgi's (1996) [SHOWIF]s and empty arguments (1997) pop-up list to select template (1999) ShowNext and random sort (1998) Search problems! (1999) Rendering out a page (1997) Multi-processor Mac info ... (1997) RE: Formulas.db + Users.db (1997) Group search doesn't work. (1997) Don't tick me off :) [elaspedtime] (1997) thankyou.tmpl (1997) form data submission gets truncated (1997) Where's Cart Created ? (1997)