[Zope] SQL errors

Andy McKay andym@ActiveState.com
Sun, 1 Oct 2000 12:54:18 -0700


Of course, thank you. That works just fine.

----- Original Message -----
From: "Dieter Maurer" <dieter@handshake.de>
To: "Andy McKay" <andym@activestate.com>
Cc: <zope@zope.org>
Sent: Friday, September 29, 2000 2:55 PM
Subject: Re: [Zope] SQL errors


> Andy McKay writes:
>  > Using ZODBC Database Adapter to connect to an MSSQL and I can call the
sql
>  > method in dtml eg:
>  >
>  > <dtml-try>
>  >   <dtml-call "SQL_add_user(REQUEST)">
>  > <dtml-except sql.error>
>  >     Error!
>  > </dtml-try>
>  >
>  > But does anyone know a way of trapping the specific error eg: database
down,
>  > key violation etc...? Or do I have to hack ZODBC to return different
errors?
> You know the "error_value" variable defined inside the "dtml-except"?
>
> Maybe, it can give you additional information about the kind
> of error.
> If it is the wrong one, reraise the exception.
>
>
> Dieter
>
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )
>