On Thursday 29 November 2001 08:53 am, Hans-Peter Harmsen allegedly wrote:

Question: I have extracted data from a database using a Z SQL Method. Now I want to know the names of the fields of the records retrieved. How do I do this?

In the documentation I keep finding: "They provide meta-data about their input parameters and result data."

How can I access this metadata?

Hans-Peter Harmsen

Try names or dictionaries, as in: <dtml-with name="MySQLMethod"> <dtml-in name="names"> <th>&dtml-sequence-item;</th> </dtml-in> </dtml-with> dictionaries makes the result into a list of dictionaries which is another way to get the names (using keys()) hth, /---------------------------------------------------\ Casey Duncan, Sr. Web Developer National Legal Aid and Defender Association c.duncan@nlada.org \---------------------------------------------------/