RE: Interesting Situation

[anim8tr]

What does the code for the form look like? Specifically, the code for the fields that maintain the previous value...

 

 -----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Sorge, Bruce
Sent: Friday, February 23, 2001 2:32 PM
To: List (E-mail)
Subject: Interesting Situation

I have the following code:

 

<CFLOOP LIST="#Fieldnames#" INDEX="CurrentField">
<CFLOOP LIST="#Form.AnswerID#" INDEX="AID">
 <CFIF CurrentField CONTAINS "Question_Freetext_">
  <CFIF Len(Trim(Evaluate(CurrentField))) GT 0>
   <CFSET FormattedField = Replace(Evaluate(CurrentField), "'", "''", "ALL")>
   <CFQUERY DATASOURCE="DOCUMENTATION">
    UPDATE Answers
    SET Answer = '#FormattedField#'
    Where AnswerID = #AID#
    
   </CFQUERY>
 </CFIF>

</cfif>

 

What is happening is that when I run this submit the form, all of the fields get updates like they should, except that all fields are being updated to whatever the last field value is. I am not sure why this is. ANyone out there that can assist? Also, if I am not being clear enough, let me know and I will try to explain better.

 

Thanks,

 

Bruce Sorge

Portal Services

Baylor Health Care Systems

Phone: 214-820-3142