[Zope] Looking up other row records in an SQLMethod?

[Dieter Maurer]

Theodore Patrick writes:
 > Is it possible to look up other SQL record values while iterating through a
 > <DTML-IN>?
I did not understand your requirements.

But the answer is yes:

	<dtml-let query_results=SQLMethod>
	  <dtml-in query_results>
	    ....
	    <dtml-var "query_results[i].field">
	      <!-- this will access "field" of the i-th row-->
	    ...
	  </dtml-in>
	</dtml-let>


Dieter