[Zope] iteration through list with dtml-tags

John Hunter jdhunter at ace.bsd.uchicago.edu
Wed Aug 7 17:09:52 CEST 2002

>>>>> "Axel" == Axel Bock <news-and-lists at the-me.de> writes:

    Axel> To submit queries I do the following:

    Axel> DB = self.dbc() 

If you can't use the DictCursor I suggested above (and it may be
difficult since it looks like you are inheriting the connection but
someone else may be able to help you here), then you can either

1) use the tuple indexing I posted earlier

2) Make a list dictionary in your python product and return it to
   dtml; this will make the dtml more readable.

results = DB.query("select first,last,pid,email from wobba")
resultDicts = []
for result in results:
  resultDicts.append( {'first' : result[0], 'last' : result[1], 
                      {'pid' : result[2], 'email' : result[3]} )

Now return resultDicts, which is a list of dictionaries.

In dtml, you can call the method like this; note the 'mapping' keyword is
critical here:

<dtml-in get_result_dicts mapping>
  <dtml-var first> <dtml-var last> <dtml-var pid> <dtml-var email>

Good luck!
John Hunter

More information about the Python-list mailing list