Help with ODBC Error Trapping

bmacman · Mar 7, 2001

Hello, I am trying to figure out how to trap an ODBC error that occurs when I pass a login id and password from a login screen to be the same user id and password to connect to a database to execute a query. The problem that I am encountering is that when a wrong password is entered, we get a generic ODBC 28000 error and we can not figure out how to trap this and customize an error response. I have included the code of the page that is accessed right after the login page:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>Developers Corner Site Access</title>

<cfquery name="Devseccheck" datasource="teradata32_edw" username="#form.user_id#" password="#form.password">
Select user_id, access(named sec_level)
from C_R.TCCRB045_BO_CNTC_SEC
where user_id = '#form.User_ID#'
</cfquery>
</head>

<body>

<cfif #Devseccheck.recordcount# is 0>
 
<CENTER>
The User ID you entered could not be located in this system. 
Please check the User ID you entered, or, 
if you would like to request access, please send a request to the
<a href="mailto:hlp@sbc.com">Contact/ECM Support Desk</a> </center>

<cfelseif #passcheck.recordcount# greater than 0>
<CFOUTPUT>
<cfif #Devseccheck.sec_level# contains "ITADM">
<CFLOCATION URL="devitadm.cfm">
<cfelseif #Devseccheck.sec_level# contains "ITCNTC">
<CFLOCATION URL="devitcntc.cfm">
<cfelseif #Devseccheck.sec_level# contains "ITECM">
<CFLOCATION URL="devitecm.cfm">
<cfelseif #Devseccheck.sec_level# contains "ITHLP">
<CFLOCATION URL="devithlp.cfm">
<cfelseif #Devseccheck.sec_level# contains "ECMMGR">
<CFLOCATION URL="devecmmgr.cfm">
<cfelseif #Devseccheck.sec_level# contains "ECMUSR">
<CFLOCATION URL="devecmusr.cfm">
<cfelse>
 
<CENTER>
You are not authorized to access the Developers Corner.
If you would like to request access, please send a request
to the <a href="mailto:hlp@sbc.com">Contact/ECM Support Desk</a>
</center>
</cfif>
</cfoutput>
</cfif>
</cfif>

</body>
</html>

Thank you for all your help

CFHub · Mar 7, 2001

You may be interested in CFCATCH/CFTRY

There are a couple examples you can look at:

http://cfhub.com/language/index.cfm?TagID=9

http://cfhub.com/advanced/cftransaction/

Basically, you could do:

<cftry>

<cfquery name="Devseccheck" datasource="teradata32_edw" username="#form.user_id#" password="#form.password">
Select user_id, access(named sec_level)
from C_R.TCCRB045_BO_CNTC_SEC
where user_id = '#form.User_ID#'
</cfquery>

<cfcatch type="Database">
..set an error messge OR
..return them to the form...
</cfcatch>
</cftry>

GunJack · Mar 7, 2001

Hey Bmacman,

Try this:

<cftry>
<cfquery name="Devseccheck" datasource="teradata32_edw"
username="#form.user_id#" password="#form.password">
Select user_id, access(named sec_level)
from C_R.TCCRB045_BO_CNTC_SEC
where user_id = '#form.User_ID#'
</cfquery>
<cfcatch>
<cfoutput>#cfcatch.message# #cfcatch.detail#</cfoutput>
</cfcatch>
</cftry>

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Help with ODBC Error Trapping

bmacman

IS-IT--Management

CFHub

Technical User

GunJack

ISP

Similar threads

Part and Inventory Search

Sponsor