[Zope-dev] SQL METHODS - Obtaining ROW IDS in an <IN> STATEMENT

Here is the situation: I have a method called item_method. It contains SQL:SELECT that returns 10 rows of data. When I want to print this to a page in ZOPE. I use an <IN> Statement as follows. Currently the data set from the database does not return a row number, so I need Zope to make one up as it prints the HTML. The data set has two columns called this and that. I need the code that generates the <!--#var ?????? --> in the following code. <!--#in item_method size=10 start=query_start--> ROW_NUM= <!--#var ?????? --> THIS=<!--#var this -->, THAT=<!--#var that --> <!--#in --> As always - Thanks in Advance. Theodore E. Patrick http://www.ishophere.com Where do you shop?