Θέμα: Re: [Zope] How to show field names from sql query?

[Thomas Apostolou]

"TestODBCEM" is an external method that uses a python
module with a function named "TestODBCEM". This
function uses the parameters sysDSN, usr, mypass, sSQL
to connect to the sysDSN with user name usr, password
mypass and execute sSQL query. After that it returns
the results witch i show in a table.


--- Tino Wildenhain <tino at wildenhain.de> wrote:

> Thomas Apostolou schrieb:
> > Hello all,
> > i use the following to get to show the results
> from an
> > sql query.
> > What are the expresions to show the field names?
> > 
> > <table>
> >   <dtml-in expr="TestODBCEM(sysDSN=sysDSN,
> usr=usr,
> > mypass=mypass, sSQL=sSQL)">
> >     <dtml-if sequence-even>
> >       <tr bgcolor="lightgreen">
> >     <dtml-else>
> >       <tr>
> >     </dtml-if>
> >     <dtml-in sequence-item>
> >       <td><dtml-var sequence-item></td>
> >     </dtml-in>
> >     </tr>    
> >   </dtml-in>
> > </table>
> > 
> 
> See:
>
http://www.zope.org/Documentation/Books/ZopeBook/2_6Edition/RelationalDatabases.stx#3-107
> 
> particulary result.data_dictionary() which gives
> you the names of the columns.
> 
> I'm not sure what you mean with the DSN in your
> example above.
> For me it does not look correct. ZSQL methods
> do not deal with databases and connections directly
> but
> rather use a central connection object.
> 



	

	
		
___________________________________________________________ 
Χρησιμοποιείτε Yahoo!; 
Βαρεθήκατε τα ενοχλητικά μηνύματα (spam); Το Yahoo! Mail 
διαθέτει την καλύτερη δυνατή προστασία κατά των ενοχλητικών 
μηνυμάτων http://login.yahoo.com/config/mail?.intl=gr