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

Theodore Patrick tpatrick@IndigoNetworks.com
Thu, 5 Aug 1999 08:20:08 -0500


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?