Jones, David H writes:
 > I have set up a direct traversal sqlMethod which has as a DTML method
 > The zsql method, sqlModel,  is:
 > select *
 > from AP_MDL 
 > where <dtml-sqltest ap_mdl_no type=string>
 > The direct traversal url is:
 > The first DTML method I wrote, asMeta, operated correctly with the following code:
 > <meta name="ap_mdl_no" content="<dtml-var ap_mdl_no>">
 > <meta name="ap_mdl_cd" content="<dtml-var ap_mdl_cd>">
 > <meta name="bus_no" content="<dtml-var bus_no>">
 > <meta name="ap_mdl_prod_ind" content="<dtml-var ap_mdl_prod_ind>">
 > Now I want to generalized the DTML method to work with any query.  I would like to 
 >reference the fields, but haven't figured out how to. Can someone tell me how to 
 >reference the fields and field names returned in a direct traversal.

The easiest way is to use a "brain" for your database records
and let one of its methods return the list of field names.
The information is contained in the attribute "__record_schema__"
(inaccessable from DTML!). "__record_schema__" is a dictionary
mapping field names to field indices (starting from 0).

Alternatively, you can use an external method, that accesses
"__record_schema__" for you and makes is accessable from


Zope maillist  -  [EMAIL PROTECTED]
**   No cross posts or HTML encoding!  **
(Related lists - )

Reply via email to