Slightly OT: Raising exceptions from the database

Tue, 26 Sep 2000 23:46:02 -0700 

This is a multi-part message in MIME format.

------=_NextPart_000_0017_01C02860.06C725E0
Content-Type: text/plain;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi all,

Does anybody know how can i raise a exception in SQL Server 7 with a =
custom message or error code that i can receive and process in CF with a =
CFCATCH tag?

I tried the RAISEERROR function but it doesn=B4t actually raise the =
error to an "exception" level... so CF can=B4t detect it as an exception =
than could be handled later...

And the bonus question: If we use Oracle instead of SQL Server 7... how =
can we do it?

Francisco Montes
Spain on Line


------=_NextPart_000_0017_01C02860.06C725E0
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>
<DIV>
<DIV><FONT color=3D#000000 size=3D2>Hi all,</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT color=3D#000000 size=3D2>Does anybody know how can i raise a =
exception in=20
SQL Server 7 with a custom message or error code that i can receive and =
process=20
in CF with a CFCATCH tag?</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=3D2>I tried the RAISEERROR function but it doesn&acute;t =
actually=20
raise the error to an &quot;exception&quot; level... so CF can&acute;t =
detect it=20
as an exception than could be handled later...</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=3D2>And the bonus question: If we use Oracle instead of =
SQL Server=20
7... how can we do it?</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=3D2>Francisco Montes</FONT></DIV>
<DIV><FONT size=3D2>Spain on Line</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV></DIV></DIV></BODY></HTML>

------=_NextPart_000_0017_01C02860.06C725E0--

------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.

Reply via email to