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

2000-08-15 Thread Theodore Patrick
Is it possible to look up other SQL record values while iterating through a DTML-IN? Sample Data returned by SQL Method: ID, ORDER 23, 1 25, 3 34, 6 39, 19 12, 23 Using a DTML IN I need to get the following during a single pass through the SqlMethod: HEADER ID ORDER PREV NEXT PASS 1

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

2000-08-15 Thread 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