[prev in list] [next in list] [prev in thread] [next in thread]
List: zope
Subject: RE: [Zope] date in Z Gadfly Database
From: "Farrell, Troy" <troy.farrell () wilcom ! com>
Date: 2000-11-30 16:18:12
[Download RAW message or body]
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.
_______________________________________________
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 )
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic