On 22.05.2001 16:22:13 +0200 Gitte Wange <gitte@mmmanager.org> wrote:
I have a query returning a timestamp column from my interbase 6 database using the Going Virtual database adapter. I want to extract the values of the day/month/year ... from the variable. I tried this
<dtml-var date_column fmt="%d">
for the day, but it doesn't work, probably because the variable's type is not the usual python DateTime. Similarly, this
<dtml-var "_.DateTime(date_column).day()">
Have you tried with: <dtml-var "_.DateTime(date_column).strftime('%d')">
Yes, I had tried that before. It gives me a "NameError" with the "Error value" being "date_column". Thanks...
Maybe it's the date_column that is wrong???
You were right, but that doesn't change my problem... I had mistyped the column's name when I retried that version in response to your mail. Now, what I really get as an error message is an "AttributeError", the "Error value" being "__int__". I had that before and I think it means that the variable can't be rendered to an integer, as python thinks it should because it doesn't know that the variable is supposed to contain a date value. Oliver -- Oliver Sturm / <sturm@oliver-sturm.de>