[Zope-DB] Re: Zope-DB Digest, Vol 42, Issue 16

2007-01-26 Thread Michael Mauws
-- next part -- An HTML attachment was scrubbed... URL: http://mail.zope.org/pipermail/zope-db/attachments/20070126/e5900565/attachment-0001.htm -- Message: 2 Date: Fri, 26 Jan 2007 08:48:31 +0100 From: Andreas Jung <[EMAIL PROTECTED]> Subjec

Re: RE : Re: [Zope-DB] modifications on a query

2007-01-26 Thread Maciej Wisniowski
> any suggestions? Write a procedure in the database that does this and just call this procedure from Zope. -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: RE : Re: [Zope-DB] modifications on a query

2007-01-26 Thread Charlie Clark
Am 26.01.2007, 14:17 Uhr, schrieb Graziella Toutoungis <[EMAIL PROTECTED]>: curs.execute("DROP TABLE test_fetch") #curs.execute(createQuery) i will integrate in zope this code to create a form in order to give the users the capability to manage my database. any suggestions? Yes, you

RE : Re: [Zope-DB] modifications on a query

2007-01-26 Thread Graziella Toutoungis
in my database i want to create a table1 who is the result of a query on table2 and table3 like select x2,y2,x3,y3 from table2 and table3... -i want now to create the table1. -evrey time the user try to insert into table1, i must insert this data in the original table and verify the possibility of

Re: [Zope-DB] modifications on a query

2007-01-26 Thread Charlie Clark
Am 26.01.2007, 08:37 Uhr, schrieb Graziella Toutoungis <[EMAIL PROTECTED]>: Hello, I use zope2.9.4 with postgresql8.1, in my database i have some tables are the result of a query on other tables. exe: table1 is the result of table2 with table3 My user can connect to the database and he ca

Re: [Zope-DB] modifications on a query

2007-01-26 Thread Maciej Wisniowski
> I use zope2.9.4 with postgresql8.1, in my database i have some tables > are the result of a query on other tables. > exe: table1 is the result of table2 with table3 > > My user can connect to the database and he can modify the table1, > this modification should done on the orginals tables tabl