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:

CGI Request Time Out (1997) Pull Down Search (2000) Where's 3.0 Online Docs? (1999) Deleting Orders (1997) Tea Room trouble (1997) Admin Edit prob. (1997) RE: protect tag on NT (1997) What is your question??? (2003) WebCatalog2 for NT Beta Request (1997) Error:Too many nested [xxx] contexts (1997) WebCat2: Formulas.db question (1997) [searchString] (1997) server side includes & webcatalog (2000) WebCat vs. ASP (1999) Sorting problem (2002) Redhat 7.3 (2002) Moment of Thanks (1997) What is the best way to share load with Web Cat and mac (2000) Include a big block of text (1997) product differences (1999)