Re: Date fun with MySQL
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58476
interpreted = N
texte = That also does not work, since the AS will actually just be an alias to cal=lit later by this name. Like I said, it works in any other SQL GUI app or th=eterminal, but not with WebDNA.Nitai--Redakto - Content Management that simply worksContent Management & eBusiness SystemsComputerOil=AE AGDammstrasse 75400 Baden / SwitzerlandTelefon +41 (0)844 44 55 66info@computeroil.comhttp://computeroil.com> From: Gary Krockover
> Reply-To: WebDNA Talk > Date: Fri, 18 Jun 2004 02:32:18 -0500> To: WebDNA Talk > Subject: Re: Date fun with MySQL>=20> Do you have to declare an "as date"?>=20> select DATE_FORMAT(bugs.mydate, '%d %m %Y') as date, users.user_name> from bugs, users> where bugs.bug_reporter =3D users.user_id> order by mydate DESC>=20> 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. :-)>=20> GK>=20> At 02:19 AM 6/18/2004, you wrote:>> Sal,>>=20>> I think we have found the problem. Using this:>>=20>> select DATE_FORMAT(bugs.mydate, '%d %m %Y'), users.user_name>> from bugs, users>> where bugs.bug_reporter =3D users.user_id>> order by mydate DESC>>=20>> 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.>>=20>> I have sent this already to Scott>>=20>> Nitai>=20>=20> -------------------------------------------------------------> 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/>=20-------------------------------------------------------------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:
That also does not work, since the AS will actually just be an alias to cal=lit later by this name. Like I said, it works in any other SQL GUI app or th=eterminal, but not with WebDNA.Nitai--Redakto - Content Management that simply worksContent Management & eBusiness SystemsComputerOil=AE AGDammstrasse 75400 Baden / SwitzerlandTelefon +41 (0)844 44 55 66info@computeroil.comhttp://computeroil.com> From: Gary Krockover > Reply-To: WebDNA Talk > Date: Fri, 18 Jun 2004 02:32:18 -0500> To: WebDNA Talk > Subject: Re: Date fun with MySQL>=20> Do you have to declare an "as date"?>=20> select DATE_FORMAT(bugs.mydate, '%d %m %Y') as date, users.user_name> from bugs, users> where bugs.bug_reporter =3D users.user_id> order by mydate DESC>=20> 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. :-)>=20> GK>=20> At 02:19 AM 6/18/2004, you wrote:>> Sal,>>=20>> I think we have found the problem. Using this:>>=20>> select DATE_FORMAT(bugs.mydate, '%d %m %Y'), users.user_name>> from bugs, users>> where bugs.bug_reporter =3D users.user_id>> order by mydate DESC>>=20>> 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.>>=20>> I have sent this already to Scott>>=20>> Nitai>=20>=20> -------------------------------------------------------------> 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/>=20-------------------------------------------------------------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/
"Nitai @ ComputerOil"
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:
Showing once on a founditems (1997)
ShowNext (1997)
Cart# (1997)
Shopping Cart variation... (1997)
shownext not showing next...still r2 (1997)
Max Record length restated as maybe bug (1997)
Summing fields (1997)
Email Set-Up? (1997)
Draft Manual, Tutorial, and more (1997)
docs for WebCatalog2 (1997)
Where is f2? (1997)
[date] problem with %d%m%Y (1998)
UPS Shipping Calculations (2001)
Which GUI HTML editors work with WC ? (1997)
WebCatalog f2 Installation (1997)
Great product and great job ! (1997)
Searching multiple fields (1997)
Avery 5160 Mailing Labels (2003)
Searching for a search solution (2000)
Re[2]: [REQ] Improved SQL context (2000)