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
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?
>
>
>
>
>
>
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
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
4 matches
Mail list logo