on my update page i have 5 textboxes and i can't seem to get the database to
update, on the previous page i used to loop to view what the user inserted
into the database, is there anyway i can use this same loop to update
records in the db, the field in the db is ans_ans, and it's related to
another table using the primary key..
on the original form where the values were inserted the form names are,
ans_answer1, ans_answer2....ans_answer5.
this is the code to view what was inserted.
<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 -->
<CFLOOP QUERY="GetAnswers">
<input type="hidden" name="ans_id#GetAnswers.CurrentRow#"
value="#GetAnswers.ans_id#">
<cfoutput><p>Answer #GetAnswers.CurrentRow#:
<input type="text" name="answer#GetAnswers.CurrentRow#" size="45"
value="#GetAnswers.ans_Ans#">
</cfoutput>
</CFLOOP>
So can i incorporate the above to update my db on my upodate page.
i'd really appreciate any help on this one!
________________________________________________________________________
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.