This is a multi-part message in MIME format.
------=_NextPart_000_00AA_01C01E86.E4833970
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi all,
A tough one... for me at least. :-)
We have got a table in SQL Server 7. In that table we have two triggers =
that always keep data in that table consistent upon insertions. Those =
triggers make sure that records comply with two rules. If an insertion =
violates a rule, the corresponding trigger raises an exception that =
effectively rolls back the whole transaction.
If an insertion goes wrong we would like to know which rule has been =
violated in order to take a different action based on it.
Is there a way of doing this?
Since CF only understands of "Database" exceptions as a whole, it =
doesn=B4t allow us to distinguish what has gone wrong exactly. Every =
trigger should respond in a different way we suppose, but... how can =
that output be processed from CF?
Francisco Montes
Spain on Line
------=_NextPart_000_00AA_01C01E86.E4833970
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type>
<META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#000000 size=3D2>Hi all,</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT color=3D#000000 size=3D2>A tough one... for me at least. =
:-)</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT color=3D#000000 size=3D2>We have got a table in SQL Server 7. =
In that=20
table we have two triggers that always keep data in that table =
consistent upon=20
insertions. Those triggers make sure that records comply with two rules. =
If an=20
insertion violates a rule, the corresponding trigger raises an exception =
that=20
effectively rolls back the whole transaction.</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>If an insertion goes wrong we would like to know =
which rule=20
has been violated in order to take a different action based on =
it.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV>Is there a way of doing this?</DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Since CF only understands of "Database" =
exceptions=20
as a whole, it doesn´t allow us to distinguish what has gone wrong =
exactly. Every trigger should respond in a different way we suppose, =
but... how=20
can that output be processed from CF?</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Francisco Montes</FONT></DIV>
<DIV><FONT size=3D2>Spain on Line</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV></BODY></HTML>
------=_NextPart_000_00AA_01C01E86.E4833970--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.