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

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


DONE

THANKS A TON - I owe you one!

-----Original Message-----
From: Tony McDonald [mailto:tony.mcdonald@ncl.ac.uk]
Sent: Thursday, August 05, 1999 8:47 AM
To: Theodore Patrick; 'zope@zope.org'; zope-dev@zope.org
Subject: Re: [Zope] SQL METHODS - Obtaining ROW IDS in an <IN> STATEMENT


At 8:20 am -0500 5/8/99, Theodore Patrick wrote:
>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 -->
>

Try <dtml-var sequence-index>,
ie ROW_NUM=<!--#var sequence-index--> THIS= etc etc.

hth
tone
------
Dr Tony McDonald,  FMCC, Networked Learning Environments Project 
http://nle.ncl.ac.uk/
The Medical School, Newcastle University Tel: +44 191 222 5888
Fingerprint: 3450 876D FA41 B926 D3DD  F8C3 F2D0 C3B9 8B38 18A2