[Zope] date in Z Gadfly Database

Farrell, Troy troy.farrell@wilcom.com
Thu, 30 Nov 2000 10:18:12 -0600


Note that Gadfly does not support the DATE datatype.  You can use VARCHAR to
store a string, or switch to a different database, such as PostgreSQL (my
personal preference) or MySQL.  The answer to your question is found here:

http://www.chordate.com/kwParsing/gadfly.html#table

The main Gadfly pages are here:

http://www.chordate.com/gadfly.html

Troy

 -----Original Message-----
From: Angietel [mailto:angietel@hotmail.com]
Sent: Thursday, November 23, 2000 2:16 AM
To: zope@zope.org
Subject: [Zope] date in Z Gadfly Database


When i create a table, one of the fields is consider as date type, but the Z
Gadfly Database does not allow me to do that, it only accepts INTEGER
instead of DATE type.

The following is my SQL for creating a table:-

CREATE TABLE customer
(custid VARCHAR(10),
custname VARCHAR(15),
custactdate DATE,
custadd1 VARCHAR(30),
custadd2 VARCHAR(30))

 
Please let me know if i got an error.Thank You.