At 02:30 20/09/99 , David Robson wrote:
Im building a few simple SQL Methods to learn my way around.
(1) Does Gadfly support a date data type? I keep getting failures in attempts to create new tables with column type DATE, but same SQL succeeds when DATE is changed to VARCHAR
This failed
CREATE TABLE pimtest ( First_Name VARCHAR, Last_Name VARCHAR, State VARCHAR, Home_Phone VARCHAR, First_Entered DATE, Last_Modified DATE)
This succeeded
CREATE TABLE pimtest ( First_Name VARCHAR, Last_Name VARCHAR, State VARCHAR, Home_Phone VARCHAR, First_Entered VARCHAR, Last_Modified VARCHAR)
(2) Also, adding field length to seemed to make table creation fail. Am I doing something wrong there?
VARCHAR worked OK VARCHAR(12) failed
Gadfly is a very simple DB, and it doesn't support Date fields. More information about Gadfly can be found in the lib/python/Products/ZGadflyDA/gadfly directory and the following URL: http://www.chordate.com/kwParsing/gadfly.html -- Martijn Pieters, Web Developer | Antraciet http://www.antraciet.nl | Tel: +31-35-7502100 Fax: +31-35-7502111 | mailto:mj@antraciet.nl http://www.antraciet.nl/~mj | PGP: http://wwwkeys.nl.pgp.net:11371/pks/lookup?op=get&search=0xA8A32149 ------------------------------------------