[Zope-dev] I'm having troubles with MySQL MONTHNAME() function

2000-10-27 Thread Andres Sanchez Gomez
Hello: I'm from Argentina, as you shoud now, I speak spanish. I'm usig MySQL, as you sould also now, it's in English. I have to give de time informatio in letters. Like 'Febrero' (02, February). I found two ways, but non of them gives me good results. The first way is to ask to the database a

Re: [Zope-dev] I'm having troubles with MySQL MONTHNAME() function

2000-10-27 Thread Julio Flores Schwarzbeck
Actually, what you need to do is place the MONTH MySQL function INSIDE your SQL Method, like so: select month(mydate) as mDate from myTable and evaluate it from zope as: dtml-if "mDate=='1'"Enero .. .. -=-=-=-=-=-=-=-=-=-=-=- ESPANOL FOLLOWS (oops) -=-=-=-=-=-=-=-=-=- De hecho, lo que