[Zope] catching exceptions thrown by gadfly db

1 Nov 2002

      Hi all,

I am trying to catch and handle an exception thrown by the gadfly db.  My code is as follows:

<dtml-try>
  <dtml-call expr="sql_add_software(p_custName=custName,swName=swName)">
<dtml-except>
    An error occurred.
    Error type: <dtml-var error_type>
    Error value: <dtml-var error_value>
</dtml-try>

The error is thrown and caught (violation of a unique constraint), but it still inserts the row in the DB.

When I try to delete the identical rows, I get the following error:

Error, exceptions.ValueError: list.remove(x): x not in list

Any ideas?

TIA,

Micheál Healy