On Jan 13, 3:23 pm, vElentari <jackien1...@gmail.com> wrote: > I'm learning ASP, MySQL, and javascript all crash-course style right > now, so please forgive me ahead of time for my ignorance! :) > > I'd like to use the Sortable feature on a page to reorder list > elements. The elements are in a MySQL database, and the site is ASP. > I have a basic HTML table that displays the list now. Each record > contains the unique ID, the name of the element, a boolean value for > whether the item should be Active or not, and an OrderBy field. I'd > like to hide that OrderBy field on the page, and instead of having the > user manually reorder the list, use the sortable drag/drop feature. > > I'm just looking for sample code on using classic ASP with a MySQL > database to grab the records, create the list and use scriptaculous to > handle the reordering for the user, and then write the new order back > to the database. > > I've found a bunch of examples out there of people using PHP and I'm > sure I can figure it out but if I don't need to recreate the wheel... > If all you want to do is make your table sortable by the user, I would suggest you don't use scriptaculous at all, but just look at Matt Kruse's table.js (http:/javascripttoolbox.com/lib/table -I'm sure there are other similar tools, but this is the one I have used). You don't have to write any Javascript at all - you just give elements in your table the right classes, and include table.js, and it does it all for you.
Of course, if you want to do other whizzy things with Script.aculo.us, then by all means use it :) > Thanks
-- You received this message because you are subscribed to the Google Groups "Prototype & script.aculo.us" group. To post to this group, send email to prototype-scriptacul...@googlegroups.com. To unsubscribe from this group, send email to prototype-scriptaculous+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/prototype-scriptaculous?hl=en.
