Skip to main content
N
Newsgroup_User
Inspiring
June 17, 2008
Question

CFTRY/CFCATCH for db inserts

  • June 17, 2008
  • 2 replies
  • 373 views
We currently don't do a cftry/cfcatch for database inserts.

What is the base way to proceed with laying this out? How can you define a
custom message if the insert fails?


    This topic has been closed for replies.

    2 replies

    T
    Turbo_Mini
    Participant
    June 24, 2008
    Define a function for handling error messages

    Then

    <cftry>
    <cfquery></cfquery>
    <cfcatch type="database">
    <cfscript>throwerror("Could not do xxxxx");</cfscript>
    </cfcatch>
    </cftry>

    D
    Dan_Bracuk
    Inspiring
    June 17, 2008
    We have one job that does this. The cfcatch part is

    <cfcatch>
    <cfmail>
    <cfdump var="#cfcatch#">


    The job runs on a schedule so we don't care about screen displays.
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices