Yes I did and thank you very much. However, it did not work. See my latest
post. I decided to try something real simple and got a different 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 :
the form generating this is:
<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>
I made all the necessary changes in the database and used non-app specific
labels so as not to confuse Access. Any ideas. Just a note: my caps lock was
stuck on and I didn't realize it. I was not angry or frustrated :)
Nick
>Did you try what I said? Here it is again in case it didn't send.
>
>Try using this query (add square brackets around the database object names
>and use CFQUERYPARAM!):
>
>SELECT *
>FROM [Users]
>WHERE [UserLogin] = <cfqueryparam cfsqltype="cf_sql_varchar"
>value="#Form.UserLogin#">
>AND [Password] = <cfqueryparam cfsqltype="cf_sql_varchar"
>value="#Form.Password#">
>
>If that works then the reason is that one of the database object names
>(column names, table names, etc) was the same as an Access function
>name/reserved word or some-such.
>
>Let me know how it goes.
>
>Dominic
>
>p.s. please don't use caps all the time, you may be in a foul mood (we've
>all been there) - but don't take it out on us!
>
>
>>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:297216
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
