[Zope] Newbie questions re SQL Methods

[Martijn Pieters]

At 02:30 20/09/99 , David Robson wrote:

>I’m 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
------------------------------------------