Really man, thanks for the help. I decided to go real simple and change
everything to test it. Here is what I did.
<cfquery name="getUser" datasource="#dsn#">
SELECT Password, FirstName, userID
FROM Users
WHERE ("#form.accessCode#" = password)
</cfquery>
<cfform name="siteAccess" action="siteAccessLogin.cfm?userIP=#REMOTE_ADDR#"
method="post">
<input type="hidden" name="accessCode">
<cfinput type="password" maxlength="25" name="accessCode" value=""
style="{height:24px; font-size:10px; font-weight:bold; color: blue;
letter-spacing:0.2em; padding-top:5px; padding-left:2px}">
<cfinput type="submit" name="accessCode" label="Enter Access Code">--->
</cfform>
Once this form is executed it uses the following code to re-direct the user to
the page they want:
<cfquery name="getUser" datasource="#dsn#">
SELECT Password, FirstName, userID
FROM Users
WHERE ('#form.accessCode#' = password)
</cfquery>
<!---Log In Argument--->
<cfif getUser.password IS 'paulw'>
<cflocation
url="../PrivateAccess/showAR.cfm?URL.imageType='#aboutRick#'">
</cfif>
<!---DENY ACCESS--->
<cfif getUser.password EQ "">
<cflocation url="accessDenied.cfm?userIP=#REMOTE_ADDR#">
</cfif>
<cfif (getUser.recordCount EQ 0)>
<cflocation url="accessDenied.cfm?userIP=#REMOTE_ADDR#">
</cfif>
However, now I am getting this error message:
Element ACCESSCODE is undefined in FORM.
The error occurred in
C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginForm.cfm: line 215
213 : SELECT Password, FirstName, userID
214 : FROM Users
215 : WHERE ("#form.accessCode#" = password)
216 : </cfquery>
217 :
I have never had so much trouble with a simple log in page before. I have
checked and re-checked the DB for any errors. Code for spelling errors etc. I
am stumped. I think I have been on this project too long and I can't see the
forest or the trees ;(
Nick
>Ok, so now you've got me in troubleshoot mode.
>
>First, does the query run outside of CF? I just noticed the *[ODBC Microsoft
>Access Driver]* part; I'm not a db guy, maybe this would change the syntax,
>even slightly?
>
>Second, are the DB fields both type 'varchar'? The cfqueryparam being used
>marks them as both, so CF is trying to bind them as such. If they are
>something else in the db, it may fail, though I wouldn't expect the message
>you're getting from that.
>Third, does the query work in CF but without the variables? Hard-code it for
>a quick test (I'd do it without the cfqueryparam even...as bare as possible,
>just to make sure it's working).
>
>That's all I can think of for now. If I come up with something else, I'll
>throw it out there.
>
>
>On Jan 23, 2008 1:00 PM, Nick Ross <[EMAIL PROTECTED]> wrote:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297207
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
