"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 <[EMAIL PROTECTED]> 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 _______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )