let's take it one step at a time...
On Jan 23, 2008 12:20 PM, Nick Ross <[EMAIL PROTECTED]> wrote:
> <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>
when you first load this page, there will be no #form.accessCode#,
since no form has been submitted. how are you expecting
#form.accessCode# to have a value here?
let's try sticking to this for now... because over the course of the
day, you've posted a number of variations which makes it hard to
troubleshoot, since we don't know what code you're working with at any
given time. so for now... just this. how are you running a query on
the form display page trying to use a form variable when a form hasn't
yet been submitted?
--
Evelyn the dog, having undergone further modification pondered the
significance of short-person behaviour in pedal depressed,
pan-chromatic resonance, and other highly ambient domains. "Arf," she
said.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:297253
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
