-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 02/01/2013 04:27 AM, murat bilal wrote:
I have DTML-Method like below <dtml-try> <dtml-call "deleteUser(USERNAME=USERNAME)">
<dtml-except> An error occurred. Entry was <b>NOT</b> deleted. </dtml-try>
deleteUser is Z-SQL method.USERNAME is the argument in Z-SQL method also column name. When i click erase button it succesfully deletes record.But if i enter an invalid username it did not throw any exceptions.
This issue is unrelated to DTML / ZSQLMethods. SQL statements like the following:: DELETE FROM some_table WHERE id = 123; don't cause exceptions to be raised for an unknown value like 123; they just affect no rows. If you need an error raised, you need to do something like create a stored procedure on the server which does that. Tres. - -- =================================================================== Tres Seaver +1 540-429-0999 tseaver@palladion.com Palladion Software "Excellence by Design" http://palladion.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with undefined - http://www.enigmail.net/ iEYEARECAAYFAlEL7m8ACgkQ+gerLs4ltQ5uVgCfYRw7x3XAfwsdoFkJCNZm1U3H DKgAoLT358rI08s8GMwanffFV4jT4f8Y =StFb -----END PGP SIGNATURE-----