[Zope] ZPT and SQL

[Jim Kutter]

I haven't tried it in ZPT, but it *should* work.

>From your code:
<table tal:define="list_ppl
python:container.show_list().dictionaries()">
     <tr tal:repeat="res list_ppl">
          <td tal:repeat="column python:res.keys()" tal:content="python:
res[column]">/td>
     </tr>
</table>

SQL methods apparently have a method dictionaries() which returns the
result rows as dictionaries.

-jim


-----Original Message-----
From: Samuele Giovanni Tonon [mailto:samu at sferacarta.com] 
Sent: Tuesday, April 20, 2004 5:38 AM
To: zope at zope.org
Subject: [Zope] ZPT and SQL


hi,
i would like to access to results from a Query without knowing before
names returned from the SQL and all with ZPT

i think it could be clear with this example:

suppose you have ZPT with this inside:

<table tal:define="list_ppl container/show_list">
     <tr tal:repeat="res list_ppl">
          <td tal:content="res/name">Name</td>
          <td tal:content="res/lastname">Lastname</td>
     </tr>
</table>


show_list is this SQL method "  SELECT * from ppl"

this work, but i would like to make that table dynamic, so that i
haven't to call esplicit the name of the column  "name" and "lastname".
Also it means that the number of td will change (so i should nest some
tal:repeat inside ).

i saw it's possible to ref to data inside res with index
( (res[0], res[1])  and i tried something like this
but it's not working.
Any tips ?

<table tal:define="list_ppl container/show_list">
   <tr tal:repeat="res list_ppl">
     <span tal:define="num python:range(len(res))">
       <span tal:repeat="vars python:res[num]">
         <td tal:content="vars">vars</td>
       </span>
     </span>
  </tr>
</table>

i tried to search on google for some example of this kind but got no
clue

TIA
Samuele

_______________________________________________
Zope maillist  -  Zope at zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )