<cfif Password eq #Password# and UserName eq #UserName#>
<cfinclude template="yourpagetoinclude.cfm">
<cfelse>
<cflocation url="yourloginpage.cfm">
</cfif>

What is the difference between the template and using the url. The template worked although it displayed the information the same page which I guess is fine. The url displayed a blank page.


<cfoutput Query = "login">
<cfif Password eq #Password# and UserName eq #UserName#>
<cfinclude template="GetPictureFromUser.cfm">
<cfelse>
<cflocation url="SignIn.cfm">
</cfif>
</cfoutput>

Just depends how you want to do it - up to you. Either display the info on the same page using cfinclude or send them off to another page using cflocation. Whatever pleases you.