[Zope] dynamically generating sql queries?

[siva k]

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?
please look at the code..
--
<dtml-in "_.range(1,6)">
<dtml-call "REQUEST.set('field','author')">
	<dtml-let field=field

	index=sequence-index

	result="field+index">


	<dtml-in     "select_sql(field=result , language=language)"  >
	<dtml-var sequence-key>
	</dtml-in >

	</dtml-let>

</dtml-in>

--
or is there a better way to generate 5 different sql quesries and display 
the result?


thank you.

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/