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_namefrom bugs, userswhere bugs.bug_reporter = users.user_idorder by mydate DESCSeems that every example that I've seen has it like that. That and I'm kinda bored so thought I'd jump on in. :-)GKAt 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:
Do you have to declare an "as date"?select DATE_FORMAT(bugs.mydate, '%d %m %Y') as date, users.user_namefrom bugs, userswhere bugs.bug_reporter = users.user_idorder by mydate DESCSeems that every example that I've seen has it like that. That and I'm kinda bored so thought I'd jump on in. :-)GKAt 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)