Good Morning,
i have a newbie question. can you have a login page that verifies a username and password from an Access db, without having a application.cfm page?
i have just a little section of my intranet that i want only
a couple of people to be able to maintain. i don't think i need any thing as detailed as an application.cfm page, or do I?
here is my code. any suggestions would be great. thanks sue
login.cfm
<FORM action="login_action.cfm" method="POST">
Username <input type="Text" name="Username">
Password <input type="password" name="Password">
<input type="Submit" name="Submit">
</FORM>
login_action.cfm
<cfquery name="logincheck" Datasource="underwriting">
SELECT username, password
FROM login
WHERE username = '#username#' AND password = '#password#'
<cfif isdefined ("#username#"
AND isdefined ("#password#"
>
<cflocation url="aunder.cfm">
<cfelse>
<cflocation url="login.cfm">
</cfif></cfquery>
i have a newbie question. can you have a login page that verifies a username and password from an Access db, without having a application.cfm page?
i have just a little section of my intranet that i want only
a couple of people to be able to maintain. i don't think i need any thing as detailed as an application.cfm page, or do I?
here is my code. any suggestions would be great. thanks sue
login.cfm
<FORM action="login_action.cfm" method="POST">
Username <input type="Text" name="Username">
Password <input type="password" name="Password">
<input type="Submit" name="Submit">
</FORM>
login_action.cfm
<cfquery name="logincheck" Datasource="underwriting">
SELECT username, password
FROM login
WHERE username = '#username#' AND password = '#password#'
<cfif isdefined ("#username#"


<cflocation url="aunder.cfm">
<cfelse>
<cflocation url="login.cfm">
</cfif></cfquery>