Rick Root wrote: > > We authenticate our users to the mainframe like this: > > <cflog log="APPLICATION" text="[authByUsername] Authorization attempt > for #UNAME# from #CGI.REMOTE_ADDR#"> > <cfquery name="auth" datasource="DB2Logins" username="#UNAME#" > password="#PWORD#"> > SELECT 1 FROM SYSIBM.SYSDUMMY1 > </cfquery> > <cflog log="APPLICATION" text="[authByUsername] Authorization success > for #UNAME#">
Shouldn't the query throw an exception if the username and password are incorrect? How are you handling that exception? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290280 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
