[Bruce Dykes]
The SQL works. I know this from the test tab of the Z SQL object I created.
So now to build a page from the query. I adapted this bit of code from the Zope Bible:
<dtml-var standard_html_header> <h2><dtml-var title_or_id> <dtml-var document_title></h2> <p> This is the <dtml-var document_id> Document in the <dtml-var title_and_id> Folder. </p>
<table> <tr><td>Company Name</td><td>TechName1</td><td>TechName3</td><td>Contact</td><td>First Name</td><td>Contact</td><td>Last
Name</td><td>Company/Department</td><td>Contact</td><td>Title</td><td>Phone
Number</td><td>PHONENUMBER2</td><td>PhoneNumber3</td><td>Fax Number</td><td>Notes</td><td>Rtenum</td><td>ShortName</td></tr> <dtml_in carrier_list> <tr> <td><dtml_var Company_Name></td>
Hope you really used <dtml-var> and not <dtml_var> as you posted here! Tom P