[Zope] Referencing sql field in a direct traversal

[Dieter Maurer]

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:
 > 
 > http://e9999.rt.cs.boeing.com:8080/DB/sqlModel/777/asMeta
 > 
 > 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
DTML.


Dieter