Re: Best Practive for Updating using cfqueryparam

2011-01-04 Thread Steve Bryant
UPDATE Pages SET Pages.DisplayOrder = WHERE Pages.PageID = OR (assuming I understand correctly): UPDATE Pages SET Pages.DisplayOrder = WHERE Pages.PageID = Or (couldn't help myself here, sorry): http://www.bryantwebconsulting.com/docs/datamgr/change-sort-order.cfm Hope tha

RE: Best Practive for Updating using cfqueryparam

2011-01-04 Thread Andrew Scott
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 loop using cfqueryparam? > > > > > >

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? UPDATE Pages SET Pages.DisplayOrder = #NewOrder# WHERE Pages.PageID = #UpdateRecord# or UPDATE Pages SET Pages.DisplayOrder = David Moore Upstat

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? UPDATE Pages SET Pages.DisplayOrder = #NewOrder# WHERE Pages.PageID = #PageIndex# ~| Order the Adobe Coldfusion