Re: [Zope] How to show field names from sql query?

2005-09-20 Thread Dieter Maurer
Thomas Apostolou wrote at 2005-9-19 13:43 +0100: i use the following to get to show the results from an sql query. What are the expresions to show the field names? The ZSQL method result has a method names returning the field names. You can use it in a dtml-let, similar to: dtml-let

Re: [Zope] How to show field names from sql query?

2005-09-20 Thread J Cameron Cooper
Thomas Apostolou wrote: 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

[Zope] How to show field names from sql query?

2005-09-19 Thread Thomas Apostolou
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