[Zope] how to get the fields returned SQL method

[Chris Withers]

Okay, a lot depends on what your query is returning.

If 'names' is not the name of a column, then ignore the rest of this message ;-)

If it is, then try the following:
<dtml-in SQL>
 <dtml-var names><BR>
</dtml-in>

- If 'SQL' returns a single row and 'names' is a single-valued column, then it should display the
value of names.
- If 'SQL' returns multiple rows and 'names' is a single-valued column, then it should display the
value of names for each row returned on a seperate line.
- If names is a multi-valued column then you should get something like
  [...,...,...]
  for each row returned.

cheers,

Chris 


If names is a single-valued column then the following should work

Eric BARROCA wrote:
> 
> Hello,
> 
> I'm trying to get a list of fields returned by a dynamic SQL query.
> I've found a howto telling me to write something like :
>         <dtml-in SQL.names>
>         <dtml-var sequence-item>
>         </dtml-in>
> But it doesn't work : I get the error "Attribute Error : names".
> I've tried with .items, .keys and .fields too.
> 
> I'd like to do the same for an LDAP query.
> 
> Any idea ? I think it's very useful and that an easy way exists but I
> can't find it.
> 
> Thanks,
> 
> EB.
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )