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
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')"
-
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
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
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