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