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 >> 23 1 null 3
PASS 2 >> 25 3 1 6
PASS 2 >> 25 6 3 19
PASS 2 >> 25 19 6 23
PASS 2 >> 25 23 19 null
Calculating the PREV and NEXT is the problem and this cannot be done via
SQL.
1. What is the syntax for writing out SQL Fields Directly?
Say in a <DTML-IN>
<dtml-var ID> <dtml-var ORDER> <dtml-var "ORDER[0]"> <dtml-var "ORDER[2]
Any Ideas??
Thanks in Advance.
Theodore E. Patrick
Ishophere.com
_______________________________________________
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )