Sorry, there was an error in my last post. It should read:
UPDATE ITEMS
SET OrderIndex = OrderIndex + 1
WHERE OrderIndex < #SelectedOrderIndex#
where SelectedOrderIndex is the order of the item you want to move.
Regards: Ayudh
+----------------------------------------------------------------+
| SOAP is the glue! Hook up your server directly to your bank. |
| Connect to VeriPay xServ, the Australian Payments Web Service. |
| Reliable, Secure, FAST: http://www.xilo.com/xserv |
+----------------------------------------------------------------+
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
