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

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

RE: [Zope] NESTED IN STATEMENTS AND PASSING VARIABLES in DTML

our point on the SQL_METHODS is a good one! I had no idea! Theodore E. Patrick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 20, 2000 1:28 PM To: Theodore Patrick Cc: [EMAIL PROTECTED] Subject: Re: [Zope] NESTED IN STATEMENTS AND PASSING VARIAB

[Zope] NESTED IN STATEMENTS AND PASSING VARIABLES in DTML

What is the DTML syntax for nested in statements. Here is an example. EXAMPLE 1: NO VARIABLE PASSING GOAL: loop 4 times and with each loop run the category_method and print out the results: id=&seq=&vid= WORKS! _

RE: [Zope] SECURITY ROLES and < DTML-IN>

PROTECTED]] Sent: Monday, July 17, 2000 10:27 AM To: 'Theodore Patrick'; '[EMAIL PROTECTED]' Subject: RE: [Zope] SECURITY ROLES and < DTML-IN> > I am having trouble rendering a in ZOPE 2.2.0 to any user > regardless of roles. > > I have allocated the proper rig

[Zope] SECURITY ROLES and < DTML-IN>

I am having trouble rendering a in ZOPE 2.2.0 to any user regardless of roles. I have allocated the proper rights to all objects used and nothing happens. The will not let any user view its contents. I am using an in a DTML Document to render the contents of an SQL_Method from and Oracle Da

RE: [Zope] ODBC connection to Oracle

We have had mixed results depending on the ODBC driver you use to make your DSN. Here is what I found. 1. Microsofts ODBC Driver for ORACLE on NT4.0, NT2000 -CREATE DSN -OK -ZOPE ZODBC -OK -ZSQL METHODS -OK 2. ORACLE ODBC DRIVER on NT 4.0, Especially NT2000 -CREA