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:

Pre-parse hell (2008) 3rd request: What are SMSI's upgrade policies? (2003) Possible Bug in 2.0b15.acgi (1997) [WebDNA] sem_open bugfix for os x version 6.2 (2012) Blank orders after update to 5.1 (2003) WebDNA Partner edition .. (2002) Can a Get or Post throw off a Ping? (1998) Secure Server (1997) Virtual Domains (1998) WebCat2b13MacPlugin - nested [xxx] contexts (1997) Blog/social networking shortcut (2007) Mail going nowhere (2003) problems with 2 tags shakur (1997) 2cd pair of eyes please. (2003) OT: Raid Software on OSX (2003) WC2b15 - [HTMLx]...[/HTMLx] problems (1997) Re[3]: 2nd WebCatalog2 Feature Request (1996) nesting limits? (1998) taxTotal, grandTotal (1997) Where has WebDNA shown up in your life? (2003)