On Wed, Mar 28, 2007 at 02:52:26PM +0000, siva k wrote: > Hi, > I have five fields in the database author1,author2..author5. > Trying to generate a parameter for the select_sql method called result, > I run into an error -cannot add type "int" to string. Could you please > say how to concatenate a string and a number?
this is a simple python mistake, nothing to do with zope really... in your example: result="'%s%d' % (field, index)" > result="field+index"> ... the stuff in quotes is a python expression, so the normal python rules apply. One solution: result="'%s%d' % (field, index)" > or is there a better way to generate 5 different sql quesries and display > the result? I guess that select_sql is a separate zsql method that is called by this one? One option would be to replace the dtml you showed us with a Script (Python) which calls select_sql and passes it appropriate parameters. Something like this (may need adjustment, I'm not sure I understand your example code): for i in range(1, 6): print context.select_sql(field=result, language=language) return printed -- Paul Winkler http://www.slinkp.com _______________________________________________ Zope maillist - Zope@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 )