2 messages in net.sourceforge.lists.plone-usersODBC dtml-var dtml-sqlvar date problems
FromSent OnAttachments
Peter MillarApr 29, 2004 9:44 pm 
Peter MillarApr 29, 2004 10:04 pm 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:ODBC dtml-var dtml-sqlvar date problemsActions
From:Peter Millar (pete@public.gmane.org)
Date:Apr 29, 2004 9:44:34 pm
List:net.sourceforge.lists.plone-users

Trying to insert into table that has a date formatted column.

I understand that if I use dtml-sqlvar there is no date type, so I thought of using a dtml-var instead. But if I do this my data is showing 1899 instead of 2004 .

I am using mxODBC database adapter .

Has anyone had any experience/success inserting into tables that have date formatted columns.

____________________________________________ Peter Millar Technical Project Manager Parasyn Controls Pty Ltd

Pete@public.gmane.org T: 61 7 3396 6388 F: 61 7 3396 6299 45 Millenium Place, Tingalpa QLD 4173 PO Box 400 Cannon Hill QLD 4170 Australia www.parasyn.com.au <http://www.parasyn.com.au/>