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
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