<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title>Untitled</title> </head> <body> <form action="/admin/auth.cfm" method="post" name="details"> <input type="text" size="30" name="uName" value="UserName" onfocus="this.value=''" /> <input type="password" size="30" name="uPass" value="PASSWORD" onfocus="this.value=''" /> <input type="submit" value="Login" /> </form> </body> </html>
Here is the auth.cfm:
<CFSET checkEntry = #<CFQUERY datasource="airport_brandon">select * from auth where userName = '#FORM.uName' and pass = '#FORM.uPass#'</CFQUERY>#> <CFIF checkEntry.recordCount NEQ 0> <CFLOCATION URL="admin.cfm"> <CFELSE> <CFOUTPUT>Your Username or Password is wrong! Please try again</CFOUTPUT> </CFIF>
For some reason it won't load the admin.cfm. Do you have any suggestions? By the way the current auth.cfm gives me this error:
The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.
The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request
Invalid CFML construct found on line 1 at column 22.
ColdFusion was looking at the following text:
The CFML compiler was processing:
< marks the beginning of a ColdFusion tag.Did you mean LT or LTE?
An expression beginning with #, on line 1, column 21.This message is usually caused by a problem in the expressions structure.
A CFSET tag beginning on line 1, column 2.
Enable Robust Exception Information to provide greater detail about the source of errors. In the Administrator, click Debugging & Logging > Debug Output Settings, and select the Robust Exception Information option.
Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.
Browser Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US) AppleWebKit/532.0 (KHTML, like Gecko) Chrome/184.108.40.206 Safari/532.0
Date/Time 14-Jan-10 07:45 PM
I took out the remote address and referrer for privacy reasons. I'm sure this error is something really stupid, and it may be what is preventing me from loading admin.cfm but I've been staring at this too long, and a fresh look might really help. I appreciate any help anyone can offer. Thanks.