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 -