Need Help with login authentication

[cfnut]

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!!!!!!!!!!!!

Select Username, Password
FROM CustTable
WHERE UserName = '#UserName#' and Password = '#Password#'

[dazzlindonna]

I assume you are using this line of code to check if the login user and pwd was successful, however, getUserName is not the name of the query you have for checking that. "login" is what you named that query, so it should say instead. Try that before debugging the rest of the code.