I have been looking up some of this stuff in my book but I just can't seem to get it. Below is my code. If my username and password are correct I want to display the page (GetPictureFromUser.cfm) If the passwords do not match up I want to display the login screen (SignIn.cfm) The code below is on a page called (CheckLogin.cfm) which is where the signin.cfm information goes. Can anyone help me!!!!!!!!!!!!
<CFQUERY datasource="A9819_myDSN" name="login">
Select Username, Password
WHERE UserName = '#UserName#' and Password = '#Password#'
<CFIF getUserName.RecordCount IS 1>
<CFSET session.errMsg="Login Failed, Try Again">
<CFSET session.errMsg="Session expired">