[Zope-dev] SQL-Output

[Andre Schubert]

Hi,

i have a little problem on outputting data from an SQL-Query. The
Problem is, that the user should select his own Fieldnames
he want to show for output. The input form sends a request to the output
form, with  a query-string and some other stuff and a key named ausgabe.

The key ausgabe is a sequence with all Fielnames the user clicked. Now
in the outputform i have a sequence looking for the search-query. If
sequence starts it prints a table-head with all selected field-names out
of the second sequence ausgabe. The problem is: my table in the
relational database has a column named 'Name'. If i write in the
sequence at bottom <dtml-var Name> then the result is the the value of
Namne is printed. But if i write <dtml-var sequence-item> and the
current item is Name then Name is printed out and not the Value of Name
from the DB.
Could anybody help me.

as

P.S.: sorry for my bad english


<dtml-in Suche size=10 start=query_start>

   <dtml-if sequence-start>

     <table width="560" border="1" bgcolor="#eeeeff">
        <tr bgcolor="#ccccff">
          <th width="30%">Name</th>
          <dtml-in "REQUEST.ausgabe">
           <th><dtml-var sequence-item>&nbsp;</th>
          </dtml-in>

        </tr>

   </dtml-if sequence-start>

        <tr>
         <td class="feld"><a href="homepage?Firmennr=<dtml-var
Firmennr>&SUBMIT=Query Start"><dtml-var Name null=""></a>&nbsp;</td>
         <dtml-in "REQUEST.ausgabe">
          <td class="feld"><dtml-var sequence-item null="">&nbsp;</td>
         </dtml-in>
        </tr>

   <dtml-if sequence-end>

      </table>

   </dtml-if sequence-end>
<p>


</dtml-in>