[Zope] Referencing sql field in a direct traversal

[Jones, David H]

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.


Regards,

David H. Jones
Boeing Phantom Works,
Mathematics and Computing Technology
425-865-6924
425-865-2964 (FAX)
david.h.jones@boeing.com