Best Practive for Updating using cfqueryparam

2011-01-04 Thread David Moore
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#

Best Practive for Updating using cfqueryparam

2011-01-04 Thread David Moore
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#

RE: Best Practive for Updating using cfqueryparam

2011-01-04 Thread Andrew Scott
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

Re: Best Practive for Updating using cfqueryparam

2011-01-04 Thread Steve Bryant
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 =