Re: Date fun with MySQL

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58475
interpreted = N
texte = Do you have to declare an "as date"? select DATE_FORMAT(bugs.mydate, '%d %m %Y') as date, users.user_name from bugs, users where bugs.bug_reporter = users.user_id order by mydate DESC Seems that every example that I've seen has it like that. That and I'm kinda bored so thought I'd jump on in. :-) GK At 02:19 AM 6/18/2004, you wrote: >Sal, > >I think we have found the problem. Using this: > >select DATE_FORMAT(bugs.mydate, '%d %m %Y'), users.user_name >from bugs, users >where bugs.bug_reporter = users.user_id >order by mydate DESC > >Will NOT WORK with WebDNA, but it does so with any other SQL Interpreter. >Seems like WebDNA can not interpret the field that DATE_FORMAT has >generated, because in the template the [mydate] is not interpreted. > >I have sent this already to Scott > >Nitai ------------------------------------------------------------- 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: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  2. Re: Date fun with MySQL ( Gary Krockover 2004)
  3. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  4. Re: Date fun with MySQL ( Gary Krockover 2004)
  5. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  6. Re: Date fun with MySQL ( "Sal D'Anna" 2004)
  7. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  8. Re: Date fun with MySQL ( "Sal D'Anna" 2004)
  9. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  10. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  11. Re: Date fun with MySQL ( "Sal D'Anna" 2004)
  12. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  13. Re: Date fun with MySQL ( eLists 2004)
  14. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  15. Re: Date fun with MySQL ( Alain Russell 2004)
  16. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  17. Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
Do you have to declare an "as date"? select DATE_FORMAT(bugs.mydate, '%d %m %Y') as date, users.user_name from bugs, users where bugs.bug_reporter = users.user_id order by mydate DESC Seems that every example that I've seen has it like that. That and I'm kinda bored so thought I'd jump on in. :-) GK At 02:19 AM 6/18/2004, you wrote: >Sal, > >I think we have found the problem. Using this: > >select DATE_FORMAT(bugs.mydate, '%d %m %Y'), users.user_name >from bugs, users >where bugs.bug_reporter = users.user_id >order by mydate DESC > >Will NOT WORK with WebDNA, but it does so with any other SQL Interpreter. >Seems like WebDNA can not interpret the field that DATE_FORMAT has >generated, because in the template the [mydate] is not interpreted. > >I have sent this already to Scott > >Nitai ------------------------------------------------------------- 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:

all records returned. (1997) [WebDNA] HTML/OS vs. WebDNA ? (2008) [WebDNA] why this error when using [shownext] with a [table]? (2009) getchars broken? (1997) Cold Fusion (1998) Using Applescript to process WebCatalog functions (1998) [OT] Apple and 128bit SSL (2003) orderfile and setlineitems (1998) NT Processor Woes (2000) Paramater Passing Value (2002) Fileinfo... (2000) Custom Shipping Charges (1997) Logging purchases (1997) Another strange one (2000) WebCat2 several catalogs? (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) Off Topic: Frames Killer? (1998) New NT beta available (1997) Nesting format tags (1997) Re:no [search] with NT (1997)