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
FROM CustTable
WHERE UserName = '#UserName#' and Password = '#Password#'
</CFQUERY>


<CFIF IsDefined("URL.GetPictureFromUser.cfm")>
<CFIF getUserName.RecordCount IS 1>
<CFSET SESSION.loggedIn="yes">
<cfset session.username="#form.UserName#">
<CFLOCATION URL="GetPictureFromUser.cfm">

<CFELSE>
<CFLOCATION URL="index.cfm?failed=yes">
<CFSET StructClear(Session)>
</CFIF>
</CFIF>

<CFIF IsDefined("URL.failed")>
<CFSET session.errMsg="Login Failed, Try Again">
<CFELSEIF IsDefined("URL.notLoggedIn")>
<CFSET session.errMsg="Session expired">

<CFELSE>
<CFSET errMsg="">
</CFIF>