[Zope] Key Error Strangeness with sql qeuries

[Julian Clark]

Hello list...

I'm having bizarre issues.
When I try to create a sql method, such as this one...


update dealer_entity
set
dealer_entity.contract_start=<dtml-sqlvar contract_start type="string" >
where dealer_entity.dealer_code = '<dtml-var dealer_code >'

I get the following error...

It's rather bizarre as I have existing queries in the same directory which
work just fine.
I'm using a login with manager/owner permissions, which is the same user
that has created the other objects in this folder.

Have you any suggestions as to what could be causing this?
zope version is 2-3-3

Thanks in Advance.

Julian Clark



Error Type: KeyError
Error Value: dealer_entity_update_contract_start
----------------------------------------------------------------------------
----
Traceback (innermost last):
  File D:\Zope\2-3-3\lib\python\ZPublisher\Publish.py, line 223, in
publish_module
  File D:\Zope\2-3-3\lib\python\ZPublisher\Publish.py, line 187, in publish
  File D:\Zope\2-3-3\lib\python\Zope\__init__.py, line 221, in
zpublisher_exception_hook
    (Object: dealer_entity_update_contract_start )
  File D:\Zope\2-3-3\lib\python\ZPublisher\Publish.py, line 171, in publish
  File D:\Zope\2-3-3\lib\python\ZPublisher\mapply.py, line 160, in mapply
    (Object: manage_test)
  File D:\Zope\2-3-3\lib\python\ZPublisher\Publish.py, line 112, in
call_object
    (Object: manage_test)
  File D:\Zope\2-3-3\lib\python\Shared\DC\ZRDB\DA.py, line 393, in
manage_test
    (Object: dealer_entity_update_contract_start )
  File D:\Zope\2-3-3\lib\python\DocumentTemplate\DT_String.py, line 540, in
__call__
    (Object: &lt;string&gt;)
  File D:\Zope\2-3-3\lib\python\DocumentTemplate\DT_In.py, line 486, in
renderwb
    (Object: dealer_entity_update_contract_start)
KeyError: (see above)