[Zope-DB] RE: Entering date info - formerly no subject

[Rob Crotty]

Neil,

Thanks for the help.  I see the concept now.  I am trying to come up to
speed on dtml, html and python simultaneously with the Access background
that automates alot of this so I need to think differently.

Rob


-----Original Message-----
From: Smith, Neil (Worcester) [mailto:Neil.Smith@npower.com]
Sent: Tuesday, June 10, 2003 9:06 AM
To: 'r_crotty@yahoo.com'; zope-db@zope.org
Subject: RE: [Zope-DB] (no subject)


I don't know about access, but for Oracle, you use a string variable and
then put a date function around it to convert to a date in the database ie
something like

WHERE date_column = TO_DATE(<dtml-sqlvar date_var type=string>,
'DD/MM/YYYY')

--
Neil

-----Original Message-----
From: Rob Crotty [mailto:r_crotty@yahoo.com]
Sent: 10 June 2003 14:54
To: zope-db@zope.org
Subject: [Zope-DB] (no subject)


Larry,

Thanks for that info.  In  my Access table I am using a text field for the
date as I have not figured out how to input as a date format from a ZSQL
method.  The types I am aware of are string, nb, float and int.  Is there
another type for date format input?

Thanks alot.

Rob




**********************************************************************

The information contained in this e-mail is confidential and intended only
for the use of the addressee. If the reader of this message is not the
addressee, you are hereby notified that you have received this e-mail in
error and you must not copy, disseminate, distribute, use or take any action
as a result of the information contained in it.

If you have received this e-mail in error, please notify
postmaster@npower.com (UK 01384 275454) and delete it immediately from your
system.

Neither Npower nor any of the other companies in the Innogy group from whom
this e-mail originates accept any responsibility for losses or damage as a
result of any viruses and it is your responsibility to check attachments (if
any) for viruses.  Npower Limited Registered office: Windmill Hill Business
Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales:
number 3653277. This e-mail may be sent on behalf of a member of the Innogy
group of companies.

**********************************************************************