Re: [Zope] SQL errors

2000-10-01 Thread Andy McKay 

Of course, thank you. That works just fine.

- Original Message -
From: "Dieter Maurer" [EMAIL PROTECTED]
To: "Andy McKay" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
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  -  [EMAIL PROTECTED]
 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 )



___
Zope maillist  -  [EMAIL PROTECTED]
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 )

Re: [Zope] SQL errors

2000-09-29 Thread Dieter Maurer 

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  -  [EMAIL PROTECTED]
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 )