2 Replies Latest reply on Aug 4, 2006 11:00 AM by Dan Bracuk

    Mail + Datasource Verification

    emmim44 Level 1
      Is there a way to verify mail and some datasources before submitting a page ? Any help will be app.
        • 1. Re: Mail + Datasource Verification
          Level 7
          emmim44 wrote:
          > Is there a way to verify mail and some datasources before submitting a page ? Any help will be app.

          Simplest way would probably just be to put your calls in a try/catch
          block to see if any errors occur. Is your concern that the mail server
          and database connections are failing?

          Matt

          --
          Matt Woodward
          mpwoodward@gmail.com
          Adobe Community Expert - ColdFusion
          • 2. Re: Mail + Datasource Verification
            Dan Bracuk Level 5
            We use a lot of different db's (oracle, redbrick, mssql, sybase) and wrote a custom tag that checks the availability of a datasource. We send it a datasource name and get back a true/false variable called dbok.

            The actual tag tries to run short queries, such as "select 1 from dual", in the case of an oracle db. It then looks at error codes in the cfcatch part. I forget the rest of the details, but I used it today.