Sorry about that
I have updated version of the code. What it does is updating all records
rathere than updating only changed records.
<cfif isDefined("btnOption")>
<cfloop index="i" from="1" to="#ListLen(form.opt)#">
<cfset variables.this=ListGetAt(form.opt,i)>
<cfloop query="getOptions">
<cfset option2=#getOptions.id#>
<cfquery name="getOptions2" datasource="cfelsunrise"
dbtype="odbc" >
select * from questionOptions where id in (#option2#) and options
='#variables.this#'
</cfquery>
<cfif getOptions2.recordcount eq 0>
<cfquery name="qryOptionSave2" datasource="cfelsunrise"
dbtype="odbc">
update questionOptions set
options='#variables.this#' where id='#option2#' and surveyID=#surveyID# and
questionID=#questionID#
</cfquery>
</cfif>
</cfloop>
</cfloop>
<cflocation url="addRemoveQuestion.cfm?surveyID=#surveyID#" addtoken="no">
</cfif>
>Did you read my response to this same question in the other thread before
>you decided to post it yet again as a duplicate thread?
>
>
>On Fri, Apr 25, 2008 at 12:37 PM, erik tom <[EMAIL PROTECTED]> wrote:
>
>>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304243
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
