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#
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#
removed!
Regards,
Andrew Scott
http://www.andyscott.id.au/
-Original Message-
From: David Moore [mailto:dgmoor...@hotmail.com]
Sent: Wednesday, 5 January 2011 9:11 AM
To: cf-talk
Subject: Best Practive for Updating using cfqueryparam
What is the best way to write the following update
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 =
4 matches
Mail list logo