[Zope] Newbie questions re SQL Methods

[David Robson]

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


Thanks!

Dave

===

David Robson            robson555@yahoo.com
Computer Support        Towson High School, MD, USA

__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com