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= l it later by this name. Like I said, it works in any other SQL GUI app or th= e terminal, but not with WebDNA. Nitai -- Redakto - Content Management that simply works Content Management & eBusiness Systems ComputerOil=AE AG Dammstrasse 7 5400 Baden / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://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:

    
  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)
That also does not work, since the AS will actually just be an alias to cal= l it later by this name. Like I said, it works in any other SQL GUI app or th= e terminal, but not with WebDNA. Nitai -- Redakto - Content Management that simply works Content Management & eBusiness Systems ComputerOil=AE AG Dammstrasse 7 5400 Baden / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://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)