[Zope] SQL

[sekter@matavnet.hu]

Hi,
I think primary key is not supported by Gadfly.
In /Products/ZGadflyDA/gadfly/gadfly.html the syntax of the Create table
statement is specified as: create table name (colname datatype[, colname
datatype...]).
Arpad Kiss

On 11-May-2000 Markus Hochreiter wrote:
> I have used the Gadfly Database Connection, not MySQL, I have tried also:
> 
> CREATE TABLE adressbook
>  (nr INTEGER,
>  vorname VARCHAR(30),
> PRIMARY KEY(nr)
>  )
> 
> 
> but no success!
> mex
> 
> -----Ursprüngliche Nachricht-----
> Von: <jeffr@odeon.net>
> An: Markus Hochreiter <mh@pernau.at>
> Cc: <zope@zope.org>
> Gesendet: 11 Mai 2000 23:13
> Betreff: Re: [Zope] SQL
> 
> 
>>
>> check out http://www.devshed.com/
>>
>> They have a howto that covers basic MySQL commands, including
>> setting up a basic table with a primary key.
>>
>> Jeff
>>
>> On Thu, 11 May 2000, Markus Hochreiter wrote:
>>
>> > Hi,
>> > How I can create a table with a primary key? I have tried the following:
>> >
>> > CREATE TABLE adressbook
>> > (nr INTEGER PRIMARY KEY,
>> > vorname VARCHAR(30)
>> > )
>> >
>> > what's wrong?
>> > I get always a error message:
>> >
>> > Error, exceptions.SyntaxError: unexpected token sequence.near ::
> 'ook\012(nr
>> > INTEGER'*' PRIMARY KEY,\012v' ******************************* current
> state
>> > = 163 expects: ',', ')', ('nomatch1',) current token = ((-8,
>> > 'user_defined_name'), 'PRIMARY')
>> >
>> >
>> > thanks for your help!
>> >
>> > mex
>> >
>> >
>> > _______________________________________________
>> > 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 )

----------------------------------
E-Mail: sekter@matavnet.hu
Date: 12-May-2000
Time: 00:29:22

This message was sent by XFMail
----------------------------------