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
 > ?
I did not understand your requirements.

But the answer is yes:


  


  
...
  



Dieter

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

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

Sample Data returned by SQL Method:

ID, ORDER
23, 1 
25, 3
34, 6
39, 19
12, 23

Using a  I need to get the following during a single pass through
the SqlMethod:

HEADER >>ID   ORDER  PREV  NEXT
PASS 1   >>231null3
PASS 2   >>253  1 6
PASS 2   >>256  319
PASS 2   >>25   19 623
PASS 2   >>25   2319   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 

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 )