"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@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/RelationalDataba...
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