[Zope] zope

Jim Sanford jsanford@atinucleus.com
Fri, 25 Feb 2000 09:03:15 -0600


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 )