What database are you using? It would probably be easier to use a database client to create the tables then just use ZSQL methods to do your insert and select queries. -jfarr ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Hi! I'm a signature virus. Copy me into your .sig to join the fun! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ----- Original Message ----- From: Pedro Silva <psilva@ruido-visual.pt> To: Zope - Questions <zope@zope.org> Sent: Tuesday, February 22, 2000 9:19 AM Subject: [Zope] Z SQL Methods

Hi,

When I create a Z SQL Method just to create a table, did I need to put any arguments in?

I created the follow SQL Method:

id - sqlcreate_table Connection id - agendaDB Arguments - (I didn't put anything here)

Query String:

CREATE TABLE registos ( nome VARCHAR(10), apelido VARCHAR(10), morada VARCHAR(50), localidade VARCHAR(30), casa INT(10), telemovel INT(10), data_nasc VARCHAR(10) )

The nome, apelido, morada, localidade, casa, telemovel and data_nasc will be the columns. When I push the Add and Test button it show up message: the query requires no input. Then I puch the Submit Query and an error is showed up: Syntax Error!!! Do I need to put any arguments? Where is the syntex error?

This Table is to be used to store some information from a form.

I maybe will need to create two more SQL Methods, one to add the form information to the respective column and another to show the table. Like to do a search to the content of the table.

Is my idea right, or I need much more stuff to do?

I would like some help, if you could help me, 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 )