[Zope] Gadfly databases syntax

Phil Harris phil.harris@zope.co.uk
Wed, 23 Feb 2000 11:30:40 -0000


Pedro,

I think that gadfly doesn't require (support?) the use of sizes in varchar
types, change your sql to:-

         CREATE TABLE registos(
              id INT,
              nome VARCHAR,
              apelido VARCHAR,
              morada VARCHAR,
              localidade VARCHAR,
              casa INT,
              telemovel INT,
              data_nasc VARCHAR
          )

Phil
phil.harris@zope.co.uk

|  -----Original Message-----
|  From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Pedro
|  Silva
|  Sent: Wednesday, February 23, 2000 11:07 AM
|  To: Zope - Questions
|  Subject: [Zope] Gadfly databases syntax
|
|
|  Hi,
|
|  I'm using a Gadfly database connection to create Z SQL Methods.
|  This is the
|  first time that I'm using this, and because I know a little of
|  SQL, it seams
|  that are some differences between Ansy SQL and Z SQL.
|
|  Now, I'm trying to create a table with the following code:
|
|         CREATE TABLE registos(
|              id INT,
|              nome VARCHAR(10),
|              apelido VARCHAR(10),
|              morada VARCHAR(50),
|              localidade VARCHAR(30),
|              casa INT,
|              telemovel INT,
|              data_nasc VARCHAR(10)
|          )
|
|  When I push the button "Change and Test", it shows a message "The query
|  requires no input". Then after I push the "Submit Query" button,
|  it gives me
|  a Syntax Error, so I figure that only could be the syntax that
|  this SQL use
|  is differente from the normal SQL.
|
|  Could anyone tell me the diffrences and/or tell me where I can
|  go to see the
|  differences?
|
|  Please send your answers to: psilva@ruido-visual.pt
|
|  Thanks,
|
|  Pedro
|
|  PS - I'm sending to you too, because I know that you must know something
|  about this and would be quicker, I hope!!!
|
|
|
|
|  _______________________________________________
|  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 )
|