[Zope] sql

[Arno Gross]

Do you want to call the create method with different table names?
If so, you can define a ZSQL method:
argument: myName
CREATE TABLE <dtml-var myName>
....

and then you can call it e.g. from a DMTL method 'createManyTable':

  <dtml-call "REQUEST.set('list',('table1','table2'))"> 
  <dtml-in list>  
    <dtml-call "REQUEST.set('myName',_['sequence-item'])"> 
   <dtml-call createTable> 
  </dtml-in> 

(What's the reason for creating many tables with just different names?)
Best regards
   Arno Gross, email: arno.gross@consotec.de


On Fri, 16 Feb 2001, HENRY Katell wrote:
> I did create a Z SQL method which create a table in a database
> 
> I would like to use automatically this method to create several tables,
> 
> i.e I would like to know how to use ' CREATE TABLE nom-table'
> 
> and give a different nom_table each time automatically
> 
> 
> thanks for answers
> 
> Katell
> 
> 
> _______________________________________________
> 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 )