RE: [Zope] ODBC connection to Oracle

2000-06-01 Thread Theodore Patrick
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

[Zope] SECURITY ROLES and DTML-IN

2000-07-17 Thread Theodore Patrick
I am having trouble rendering a DTML IN 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 IN will not let any user view its contents. DTML IN I am using an IN in a DTML Document to render the contents of an SQL_Method

[Zope] NESTED IN STATEMENTS AND PASSING VARIABLES in DTML

2000-07-20 Thread Theodore Patrick
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: dtml-in "1,2,3,4" dtml-in "category_method(id='1')"

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

2000-07-20 Thread Theodore Patrick
- Your 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 STATEMENT

[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