[Zope] Zope SQL Method

[Phil Harris]

Pedro,

If your using GadFly try substituting INTEGER for INT

Make your query look like this:

CREATE TABLE Registos
(Nome VARCHAR,
Apelido VARCHAR,
Morada VARCHAR,
Localidade VARCHAR,
Casa INTEGER,
Telemovel INTEGER,
Data_nasc VARCHAR)


This works (tested 8¬/).

HTH

Phil
phil.harris@zope.co.uk


----- Original Message -----
From: "Pedro Silva" <psilva@ruido-visual.pt>
To: "Zope - Questions" <zope@zope.org>
Sent: 28 February 2000 18:17
Subject: [Zope] Zope SQL Method


> Hi Zopits,
>
> I'm trying to use the Z SQL Method to create a table. I have the following
> code in that:
>
> CREATE TABLE Registos
> (Nome VARCHAR(10),
> Apelido VARCHAR(10),
> Morada VARCHAR(50),
> Localidade VARCHAR(30),
> Casa INT,
> Telemovel INT,
> Data_nasc VARCHAR(10))
>
> When I push the Submit Query button, it gives me a error: "Syntax Error".
>
> Where could that syntax error be? I already looked to the code and I fine
> him right, so I can't figure where the error could be.
>
> Can anyone help me on this?
>
> Please send your answers to: psilva@ruido-visual.pt
>
> Thanks,
>
> Pedro
>
>
> _______________________________________________
> 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 )
>