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:

[LOOKUP] (1997) Search/sort in URL Was: GuestBook example (1997) Re2: Calculating multiple shipping... (1997) Opening 'order file'. (1999) elmer fudd (2004) [WebDNA] test (2011) Ok here is a question? (1997) Adding up weights (1998) [movefile] (1999) Was it something I said??? (1998) Overwiting SKU in Cart (2002) WebCat2 Append problem (B14Macacgi) (1997) PSC recommends what date format yr 2000??? (1997) [REFERRER] bug? (1998) founditems (1998) Running _every_ page through WebCat ? (1997) [WebDNA] WebDNA and Facebook (2009) Thanks and Big News!!! (1997) Storebuilder Seems to have just died (2003) cart info (1998)