Inserting date/time/boolean fields in table using dtml-sqlvar in ZSQLMethod
Hi all! How can I insert a record in a table using ZSQLMethod, if I have got date, time or boolean fields? dtml-sqlvar allows only string, int, float and nb types. Thanks in advance, Igor Leturia
For boolean int worked fine for me. I don't know about dates though. Try int or string and see. ----- Original Message ----- From: "Igor Leturia" <IGOR@emun.com> To: <zope@zope.org> Sent: Sunday, January 27, 2002 1:44 PM Subject: [Zope] Inserting date/time/boolean fields in table using dtml-sqlvar in ZSQLMethod Hi all! How can I insert a record in a table using ZSQLMethod, if I have got date, time or boolean fields? dtml-sqlvar allows only string, int, float and nb types. Thanks in advance, Igor Leturia _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Igor Leturia writes:
How can I insert a record in a table using ZSQLMethod, if I have got date, time or boolean fields? dtml-sqlvar allows only string, int, float and nb types. My experience tells me that date/time handling is not standardized by SQL and highly database dependant. For Oracle, I always used the "to_date" function to let Oracle convert a string into a date.
Dieter
participants (3)
-
Dieter Maurer -
Igor Leturia -
Lennart Regebro