I never really understood this all that well from the bygone ages.
In the following code if the user enters an incorrect username &/or
password the code will crash as the connection can't be made. Naturally
this won't do so I need to trap the error. Ideally setting a flag so that I
can include a template footer in the login page telling the user wrong
details please try again type thing.
So how do I trap the error to stop CF from crashing out ......? (Adrian
want to have a go at this one?)
Regards - Paul
<cfif isdefined("session.loggedin")>
<CFQUERY NAME="alldata"
DATASOURCE="SecureDSN"
username = '#decrypt(session.UserName,
application.key)#'
password = '#decrypt(session.password,
application.key)#'>
SELECT *
FROM Test
WHERE 0=0
</CFQUERY>
<!--- Something here? to catch the error of the wrong username &
password. --->
<!---Take user back to password login page with added note about
incorrect details --->
<!--- Maybe the catch / throw has to be around the query to be
triggered? --->
<cfoutput query="alldata">
#Name#
#Address#
</cfoutput>
<cfelse>
<cfoutput>
Before you can access this data you need to <a href
="loggedin/password.cfm" target="_top">login</a>
</cfoutput>
</cfif>
*************************************************************************************************
The information contained within this e-mail sent by Birmingham City Council is
confidential and is intended for the named recipient only. If you are not the intended
recipient please notify us by telephone immediately on +(44) 121 303 6666
(International) or return it to us by e-mail quoting the name of the sender and the
addressee.
*************************************************************************************************
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]