[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