<cfset loopcount=0>
<cfloop index="UpdateRecord" list="#FORM.RecordsToUpdate#">
<cfset loopcount = loopcount+1>
<cfquery name="updDisplayOrder" datasource="#DSN#">
UPDATE Pages
SET Pages.DisplayOrder = <cfqueryparam cfsqltype="cf_sql_integer"
value="#ListGetAt(FORM.DisplayOrder, loopcount)#">
WHERE Pages.PageID = <cfqueryparam cfsqltype="cf_sql_integer"
value="#UpdateRecord#">
</cfquery>
</cfloop>
OR (assuming I understand correctly):
<cfset loopcount=0>
<cfloop index="UpdateRecord" list="#FORM.RecordsToUpdate#">
<cfset loopcount = loopcount+1>
<cfquery datasource="#DSN#">
UPDATE Pages
SET Pages.DisplayOrder = <cfqueryparam cfsqltype="cf_sql_integer"
value="#loopcount#">
WHERE Pages.PageID = <cfqueryparam cfsqltype="cf_sql_integer"
value="#UpdateRecord#">
</cfquery>
</cfloop>
Or (couldn't help myself here, sorry):
<cfset Application.DataMgr.saveSortOrder("Pages ","DisplayOrder
",FORM.RecordsToUpdate)>
http://www.bryantwebconsulting.com/docs/datamgr/change-sort-order.cfm
Hope that helps,
Steve
> What is the best way to write the following update loop using
> cfqueryparam?
>
> <cfset loopcount=0>
> <cfloop index="UpdateRecord" list="#FORM.RecordsToUpdate#">
> <cfset loopcount = loopcount+1>
> <cfset NewOrder=#ListGetAt(FORM.DisplayOrder, loopcount)#>
> <cfquery name="updDisplayOrder" datasource="#DSN#">
> UPDATE Pages
> SET Pages.DisplayOrder = #NewOrder#
> WHERE Pages.PageID = #UpdateRecord#
> </cfquery>
> </cfloop>
>
> or
>
> <cfset loopcount=0>
> <cfloop index="UpdateRecord" list="#FORM.RecordsToUpdate#">
> <cfset loopcount = loopcount+1>
> <cfquery name="updDisplayOrder" datasource="#DSN#">
> UPDATE Pages
> SET Pages.DisplayOrder = <cfqueryparam cfsqltype="cf_sql_integer"
> value="#ListGetAt(FORM.DisplayOrder, loopcount)#"
> WHERE Pages.PageID = #UpdateRecord#
> </cfquery>
> </cfloop>
>
> David Moore
> UpstateWeb
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340434
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
