[Zope] SQL Errors !!

Joshi, Sunit sjoshi@ingr.com
Tue, 5 Oct 1999 11:58:14 -0500


Hello All

	First of all thanks for replying to my earlier mail where I'm trying
to use the 	SQL method:
	select ta.Name as Name, tb.DeptNo as DeptNo, tb.Title as Title,
tb.Salary as 	Salary
	from tblFacts ta, tblEmployee tb
	where ta.EmployeeID = tb.EmployeeID
	order by DeptNo

	The SQL runs fine when tested in Zope, however when used in a DTML
doc, I get this
	error message
		Error Type: KeyError
		Error Value: Name

	This is my DTML doc

<table border="1">
  <tr>
    <th align="center"><strong>Name</strong></th>
    <th align="center"><strong>Department</strong></th>
    <th align="center"><strong>Title</strong></th>
    <th align="center"><strong>Current Salary</strong></th>
  </tr> 

<--#in sqlShowEmployees--> 
  <tr>
    <td><!--#var Name--></td>
    <td><!--#var DeptNo--></td>
    <td><!--#var Title--></td>
    <td><!--#if expr="Salary > 45000"-->
        <font color="FF0000">
        <center>$<!--#var Salary--></center>
      </font>
      <!--#else-->
        <center>$<!--#var Salary--></center>
      <!--#/if-->
    </td>
  </tr>

<--#/in--> 
</table>

Any ideas..???
thanks
Sunit