Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

login page without application.cfm????

Status
Not open for further replies.

susanh

MIS
Joined
Jan 16, 2001
Messages
229
Location
US
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=&quot;login_action.cfm&quot; method=&quot;POST&quot;>
Username <input type=&quot;Text&quot; name=&quot;Username&quot;>
Password <input type=&quot;password&quot; name=&quot;Password&quot;>
<input type=&quot;Submit&quot; name=&quot;Submit&quot;>
</FORM>

login_action.cfm
<cfquery name=&quot;logincheck&quot; Datasource=&quot;underwriting&quot;>
SELECT username, password
FROM login
WHERE username = '#username#' AND password = '#password#'

<cfif isdefined (&quot;#username#&quot;) AND isdefined (&quot;#password#&quot;)>
<cflocation url=&quot;aunder.cfm&quot;>
<cfelse>
<cflocation url=&quot;login.cfm&quot;>
</cfif></cfquery>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top