when you loop through the query, you only need to do it once - thats why its
a called a loop...so instead of all those <CFLOOPs and the <cfoutput
query="getanswers">, try:
<!--- set a counter to use in the names of the variables --->
<CFSET variables.count = 0>
<CFOUTPUT QUERY="GetAnswers">
<!--- increase the counter for each iteration of the loop --->
<CFSET variables.count = variables.count+1>
<!--- now use variables.count to name your form fields --->
Answer#variables.count#:
<INPUT TYPE="text"
NAME="answer#variables.count#"
SIZE="45"
VALUE="#GetAnswers.ans_Ans#">
<INPUT TYPE="hidden"
NAME="ans_id#variables.count#"
VALUE="#GetAnswers.ans_id#">
<BR>
</CFOUTPUT>
Bert Dawson
> -----Original Message-----
> From: janey smith [mailto:[EMAIL PROTECTED]]
> Sent: 12 July 2000 17:01
> To: [EMAIL PROTECTED]
> Subject: pass variables
>
>
> i have a problem passing variables to an edit page, it passes
> the field
> pol_question fine but for the answer fields my loop is
> incorrect, it just
> reproduces the answers 5 times each. each answer is the
> ans_answer table is
> related to the pol_question through the pol_id, any help would be
> appreciated,
>
>
> <html>
> <head>
> <title>Update Poll</title>
> </head>
>
> <body bgcolor="#FFFFCC" link="#996633" vlink="#CC9966"
> alink="#CC9966">
>
> <!--- <CFIF ISDEFINED("#url.Pol_id#")>
> No Pol_id Passed!
> </CFIF> --->
>
> <CFQUERY NAME="GetPollDetails" DATASOURCE="quickpoll">
> SELECT pol_ID, pol_Question, pol_Category, pol_Status
> FROM pol_Poll
> WHERE pol_ID = #URL.PollID#
> </CFQUERY>
>
> <CFQUERY NAME="GetAnswers" DATASOURCE="quickpoll">
> SELECT ans_ID,ans_Ans
> FROM ans_Answer A
> WHERE ans_pol_ID = #url.PollID#
> </CFQUERY>
> <!-- Display HTML FORM Here with values filled -->
> <cfoutput query="getpolldetails">
> <form method="POST" action="PollUpdate.cfm">
> <!--- <textarea rows="5" name="MainText" cols="45"> --->
>
> <p> </p><p>Poll: <input type="Text" textarea rows="5" cols="45"
> name="pol_question" size=40 value="#pol_question#">
> <!--- <INPUT NAME="question" SIZE=10 VALUE="#pol_question#"> --->
>
> <!--- <input type="hidden" name="pol_ID" value="#url.pol_id#">
> ---></p></cfoutput>
>
>
> <CFSET Ans1="">
> <CFSET Ans2="">
> <CFSET Ans3="">
> <CFSET Ans4="">
> <CFSET Ans5="">
>
> <!--- get first record --->
> <CFLOOP QUERY="GetAnswers">
> <CFSET Ans1=#ans_Ans#>
> <input type="hidden" name="ans_id1" value="#ans_id#">
> </CFLOOP>
>
> <!--- get second record etc the cfloop may not work as coded! --->
> <CFLOOP QUERY="GetAnswers">
> <CFSET Ans2=#ans_Ans#>
> <input type="hidden" name="ans_id2" value="#ans_id#">
> </CFLOOP>
>
> <CFLOOP QUERY="GetAnswers">
> <CFSET Ans3=#ans_Ans#>
> <input type="hidden" name="ans_id3" value="#ans_id#">
> </CFLOOP>
>
> <CFLOOP QUERY="GetAnswers">
> <CFSET Ans4=#ans_Ans#>
> <input type="hidden" name="ans_id4" value="#ans_id#">
> </CFLOOP>
>
> <CFLOOP QUERY="GetAnswers">
> <CFSET Ans5=#ans_Ans#>
> <input type="hidden" name="ans_id5" value="#ans_id#">
> </CFLOOP>
>
>
> <cfoutput query="getanswers">
> <p>Answer1:
> <input type="text" name="answer1" size="45" value="#Ans1#">
> <br>
> Answer2:
> <input type="text" name="answer2" size="45" value="#Ans2#">
> <br>
> Answer3:
> <input type="text" name="answer3" size="45" value="#Ans3#">
> <br>
> Answer4:
> <input type="text" name="answer4" size="45" value="#Ans4#">
> <br>
> Answer5:
> <input type="text" name="answer5" size="45" value="#Ans5#">
> <br>
> </p></cfoutput>
> <p>Status:
> <select name="status" size="1">
> <option value="All">All</option>
> <option value="New">New</option>
> <option value="Active">Active</option>
> <option value="Archive">Archive</option>
> <option value="Hide">Hide</option>
> </select>
> Category:
> <select name="category" size="1">
> <option value="All">All</option>
> <option value="sports">sports</option>
> <option value="current affairs">current affairs</option>
> <option value="general">General</option>
> </select>
> <!--- Above need code to select the correct value should
> create function
> or just use
> IFS Poll Type: --->
> <INPUT name=polltype type=radio value=Y>
> Yes/No
> <INPUT name=polltype type=radio value=M>
> Multiple Choice </p>
> <p>
> <input type="submit" value="Update Poll" name="submit"></form>
> </p>
>
> </body>
> </html>
>
>
>
>
> ______________________________________________________________
> __________
> Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.