Passing variables from an initial page to a second and then third page

ma701sd · Dec 16, 2000

Hi,
Sorry, this is long one!

I'm trying to create a login procedure with the facility whereby if a password is forgotten, users can enter their username and surname to retrieve their password reminder question. This bit is OK!
On the action pag where the users question is displayed (or not in the case of not a valid user) I provide a form field where the user can enter their answer. The problem I'm having is that the second action page (GetpasswordreminderAnswer.cfm) displays all records.

I have tries to pass the hidden form from the initial page to the second and third action page but it doesnt seem to be passing it in. I get the error #Form.userName# not valod blah blah.

Can anyone help as tjis really getting on my nerves??

Many thanks

Sam

bobbyr · Dec 17, 2000

You may want to put the Username in a session variable, ie. on page 2, put <cfset Session.Username = "#Form.Username#">.

Otherwise, make sure you have all your boxes (hidden and text) within the <form> tag, and make sure the text box has name="username".

Page 1:

<form action="page2.cfm" method="post">
<input type="text" name="username">
<input type="submit" value="Submit">
</form>

Page 2:

<cfquery name="getquestion" datasource="DBConn">
SELECT Question FROM Question_Table
WHERE Username = #Form.Username#
</cfquery>

<form action="page3.cfm" method="post">
<input type="hidden" name="username" value="#Form.Username#>
<cfoutput query="getquestion">
#Question#
</cfoutput>

Answer:
<input type="text" name="answer">
<input type="submit" value="Submit">
</form>

Page 3:

<cfquery name="getanswer" datasource="DBConn">
SELECT Answer FROM Question_Table
WHERE Username = #Form.Username#
</cfquery>
blah, blah, blah

Hope this helps! If not, you may want to include some code so that we can see what's going on..

Bobby R

ma701sd · Dec 18, 2000

Hi Bobbyr,

Many Thanks for your response..It does not give me the "from.UserName" error but now i seem to get a different error message.
Basically i've put Vaidation into the the first name i.e. if Username and password is true then display "passwordreminderquestion" else error,however, if i enter a valid username and password and get the correct question - to which I reply, it tells me that no such user exists yet the validation is the same as before i.e. extract the unique user I entered.

Im attaching the code for the three pages, its long so I hop you dont mind (You did say to attach code

)

ForgottenPassword.cfm
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<HTML>
<HEAD>
<TITLE>Forgotten Password</TITLE>
</HEAD>

<BODY>
<CFFORM ACTION="getPasswordReminderquestion.cfm" METHOD="POST">

For us to be able to locate your password, simply supply your username and email address in the boxes below:<BR><BR>

Please enter your user name:
<CFINPUT TYPE="Text" NAME="UserName" REQUIRED="YES" MESSAGE="Please Enter a UserName"><BR>
Please enter your Last Name:
<CFINPUT TYPE="Text" NAME="SurName" REQUIRED="YES" MESSAGE="Please Enter your Last Name"><BR>
<INPUT TYPE="submit" VALUE="process">
<INPUT TYPE="reset" VALUE="Clear"><BR>
</CFFORM>

</BODY>
</HTML>

GetpasswordReminderquestion.cfm
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">



<CFQUERY DATASOURCE= "ONLINE" NAME="Retrieve_Question">
SELECT Username, Email, PasswordReminderQuestion,PasswordReminderAnswer, Surname
FROM Users
WHERE UserName = '#Form.UserName#' AND SurName= '#form.SurName#'

</CFQUERY>

<HTML>
<HEAD>
<TITLE>Retrieve Member login details</TITLE>
</HEAD>

<BODY>

<CFIF #Retrieve_Question.RecordCount# IS 0>

<CFOUTPUT>
Im Sorry, the name <B>#UserName#</B> and Last Name <B>#SurName#</B> that you entered does not match a valid user.<BR>
You need to either <A href="NewUser.cfm"> create an account </A> or
<A href="ForgottenPassword.cfm"> Try again</A> </CFOUTPUT>

<CFELSE>
<CFFORM ACTION = "GetPasswordReminderAnswer.cfm" METHOD ="POST">
<INPUT TYPE="hidden" NAME="UserName" VALUE="#FORM.UserName#">
<INPUT TYPE="hidden" NAME="SurName" VALUE="#FORM.SurName#">

<CFOUTPUT QUERY = "Retrieve_Question">
Your User Name is #UserName#<BR>
Your Last Name is #SurName#<BR>

Your Password Reminder Question is #PasswordReminderQuestion#<BR>

Please Enter your answer to the question:
<CFINPUT MESSAGE="You must enter your answer" REQUIRED = "Yes" TYPE="Text" NAME="PasswordReminderAnswer">
<INPUT TYPE="submit" VALUE="process">
<INPUT TYPE="reset" VALUE="Clear"><BR>

</CFOUTPUT>

</CFFORM>

</CFIF>

</BODY>
</HTML>

Getpasswordreminderanswer.cfm
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<CFQUERY DATASOURCE= "ONLINE" NAME="Retrieve_Password">
SELECT UserName, Password, Email, PasswordReminderQuestion, PasswordReminderAnswer, Surname
FROM Users
WHERE UserName = '#FORM.UserName#' AND SurName= '#form.SurName#'



</CFQUERY>

<HTML>
<HEAD>
<TITLE>Retrieve Password</TITLE>
</HEAD>

<BODY>

<CFIF #Retrieve_Password.recordcount# is 0 >
<CFOUTPUT>
Im Sorry, the answer <B>#PasswordReminderAnswer#</B> to your question is invalid.<BR>
You need to either <A HREF="NewUser.cfm"> create an account </A> or
<A HREF="ForgottenPassword.cfm"> Try again</a>
</CFOUTPUT>

<CFELSE>

<CFOUTPUT QUERY = "Retrieve_Password">

You may now log in with the following details:<BR>
User Name : <B>#UserName#</B>
Password : <B>#Password#</B><BR><BR>
</CFOUTPUT>
</CFIF>
</BODY>
</HTML>

This is really starting to cheese me off coz just when I thought I understood SQL this happens. My understanding is that if I create a search where username =username and password=password then surely only one record is matched yet CF says it zero recordcounts???

Im really sorry, I know this is long.

Your help will be greatly appreciated

Many thanks and best regards

Sam

PS - The code is a bit raw and messy so please excuse

iza · Dec 19, 2000

try to display the values of form.surname and form.username in the getpasswordreminderanswer page
i guess that they are somehow wrong (i bet it's #form.username# that is dislayed instead of the value), that's why you don't get an answer from the db
this comes from on the previous page you don't include them within cfouput
buti'm not 100 % sure

Guest_imported · Dec 19, 2000

There are ways to pass variables from page to page using hidden form fields.

The other approach is to build a "dynamic form" template, one in which the hidden fields get added dynamically. Take a look at this script if you have never done anything like this before...

http://cfhub.com/discussion/viewmessages.cfm?Forum=11&Topic=90

ma701sd · Dec 19, 2000

Hi Iza,
Thanks for the reply, You are right, it does display it as #form.username# and #form.surname#

But, How would I correct this problem. Would it be possibe for you to tell me how to fix it. This has stumped me for a few days now!

Cfhub.com - Thanks for the reply, however when I click on the link, it cannot find the page..It gives a #Form.url# error.

iza · Dec 20, 2000

you have to enclose the #variable# between <cfoutput> tags to get their VALUE passed
see this part :
<INPUT TYPE="hidden" NAME="UserName" VALUE="#FORM.UserName#">
the value is #FORM.UserName#
if you want it to be the value of #FORM.UserName#, just use
<INPUT TYPE="hidden" NAME="UserName" <cfoutput>VALUE="#FORM.UserName#"</cfoutput>>

ma701sd · Dec 22, 2000

Thanks Iza for your help...
However, Im now encountering another problem

I created a new thread if you're interested

Thanks once again

Same

iza · Dec 22, 2000

i haven't seen your new thread yet .. but i'm happy to have helped with this one

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!

Passing variables from an initial page to a second and then third page

ma701sd

IS-IT--Management

bobbyr

Programmer

ma701sd

IS-IT--Management

iza

Programmer

Guest_imported

New member

ma701sd

IS-IT--Management

iza

Programmer

ma701sd

IS-IT--Management

iza

Programmer

Similar threads

Part and Inventory Search

Sponsor