Try adding a semicolon (;) to the end of the SQL statements. Some dialects of SQL need it. I am not sure if Gadfly is one but it will only take a few seconds to try it. __________________________________________________________________ Jim Sanford . Database/Web Engineer / \ / Accelerated Technology, Inc. / / 720 Oak Circle Drive East / / \ Mobile, AL 36609 / / \ Voice: 334-661-5770 fax: 334-661-5788 / \ E-Mail: jsanford@atinucleus.com Web: http://www.atinucleus.com Source Code, No Royalties, Any CPU...It just make sense ! __________________________________________________________________ ----- Original Message ----- From: <Jatwood@bwanazulia.com> To: Pedro Silva <pedro.silva@ruido-visual.pt>; Zope - Questions <zope@zope.org> Sent: Friday, February 25, 2000 6:44 AM Subject: Re: [Zope] zope First thing is that if you add it once, you can't add it again. (try using the edit feature). Also, if you are creating a table, it will only create once and you should go to the database connection and use "browse" to see if the table is there. You should also supply the list with the error so we can see if it is in the database or zope. JMA At 11:57 AM +0000 2/25/2000, Pedro Silva wrote:

hi,

I'm trying to use Z SQL Methods with the Gadfly DataBase Connection, but this is making me crazy!!! I can't put this working!!!

I'm using the following code to create a table:

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))

At the first time that I used this code, it used to give me a Syntax Error. Now it gives me a Bad Request Error when I puch the "Add and Test" button. I don't know why is he doing this and is this that is driving me crazy, why one time this was giving me an error and now this is giving me another one!!!!??

Please can anyone help me, where is the error or another ways to make this work?

Thanks, please send your answers to: psilva@ruido-visual.pt

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 )

_______________________________________________ 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 )