RE: Saving updated sort order in mysql jquery list to update database

2013-09-26 Thread David Phelan
e...@it-werks.com] Sent: Wednesday, September 25, 2013 7:43 PM To: cf-talk Subject: Saving updated sort order in mysql jquery list to update database I have a cfm page that displays a drag and drop ul list and I do not know how to create an array of that sorted list to the mysql database. Any help woul

Re: Saving updated sort order in mysql jquery list to update database

2013-09-25 Thread .jonah
The callback called after you drop your sorted item should place an ajax call to your selected endpoint with a list of IDs in their new order. (I haven't used the jQuery UI sortables to know the details.) Then on the CF side just update the DB. A naive way might be like this: UPDATE item

Saving updated sort order in mysql jquery list to update database

2013-09-25 Thread te...@it-werks.com te...@it-werks.com
I have a cfm page that displays a drag and drop ul list and I do not know how to create an array of that sorted list to the mysql database. Any help would be greatly appreciated. I am new to the jquery, jquery-ui plugins, but loving it all so far. Thanks in advance, Terry