The updated query is here. Its updates all fields rather than only modified
fields
<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>
>First, "it does not seem to be working properly" is not a useful description
>of a problem. WHAT is it doing that makes you think it is not working
>properly. You must explain yourself. I have sent over the link to the Smart
>Questions page to you on many occasions, but clearly you still have never
>read it. http://catb.org/~esr/faqs/smart-questions.html
>
>Second, why aren't you using a list loop to loop over the list?
>
>Third, the cfif is only going to do anything if the recordcount is 0, which
>means the second query will never work.
>
>Fourth, you ignored Bobby's advice to actually read a basic ColdFusion book.
>Can I turn this into a plea? Can you please, please read a basic ColdFusion
>book and a basic SQL book? Why won't you do this?
>
>
>
>On Fri, Apr 25, 2008 at 9:17 AM, 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:304242
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
