I have TableA with name, description, start time displayed on one page. TableB has name, comment, file path and is displayed on another page. I''m using the SortHelper2 helper to help me sort the columns of these tables, however I''m experiencing a problem whereby if I sort TableA by description and then go ahead and view TableB I get an error message saying SQL Command Failed, Invalid column name ''description''. This is obviously because SortHelper is remembering the last chosen column to sort by, and the description column doesn''t exist in TableB. So is SortHelper only designed to assist with sorting just the one table per application (which seems silly to me), or am I missing something here? I''ve had a quick search on SortHelper and posts are few and far between, so if someone can suggest an alternative sorting plugin/helper instead please go ahead! -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
> This is obviously because SortHelper is remembering the last chosen > column to sort by, and the description column doesn''t exist in TableB. > > So is SortHelper only designed to assist with sorting just the one table > per application (which seems silly to me), or am I missing something > here?On the SortHelper2 page there''s a snippet at the bottom where the dev mentions multiple tables and how to get the code to do them. "I have modified this to work with sorting on multiple tables. Email me if you need the code, don''t feel like cleaning it up if no one wants it. (http://oregonstate.edu/tools/mailform?osu=43568971303&recipient=George+Harkin) -George" http://wiki.rubyonrails.org/rails/pages/SortHelper2 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Chuck Vose wrote:>> This is obviously because SortHelper is remembering the last chosen >> column to sort by, and the description column doesn''t exist in TableB. >> >> So is SortHelper only designed to assist with sorting just the one table >> per application (which seems silly to me), or am I missing something >> here? > > On the SortHelper2 page there''s a snippet at the bottom where the dev > mentions multiple tables and how to get the code to do them. > > "I have modified this to work with sorting on multiple tables. Email > me if you need the code, don''t feel like cleaning it up if no one > wants it. > (http://oregonstate.edu/tools/mailform?osu=43568971303&recipient=George+Harkin) > -George" > > http://wiki.rubyonrails.org/rails/pages/SortHelper2Yes, i have tried that. Unfortunately the mail gets bounced back. Fortunately i''ve found an alternative. Thanks anyway. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Hi Paul, I''ve posted my update to the SortHelper online: http://montanaharkin.net/2007/08/02/rails-sorthelper2-multiple-table-coumn-sorting/ Cheers, George On Jul 31, 1:30 am, Paul Nichols <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> Chuck Vose wrote: > >> This is obviously because SortHelper is remembering the last chosen > >> column to sort by, and the description column doesn''t exist in TableB. > > >> So is SortHelper only designed to assist with sorting just the one table > >> per application (which seems silly to me), or am I missing something > >> here? > > > On the SortHelper2 page there''s a snippet at the bottom where the dev > > mentions multiple tables and how to get the code to do them. > > > "I have modified this to work with sorting on multiple tables. Email > > me if you need the code, don''t feel like cleaning it up if no one > > wants it. > > (http://oregonstate.edu/tools/mailform?osu=43568971303&recipient=Georg...) > > -George" > > >http://wiki.rubyonrails.org/rails/pages/SortHelper2 > > Yes, i have tried that. Unfortunately the mail gets bounced back. > > Fortunately i''ve found an alternative. Thanks anyway. > -- > Posted viahttp://www.ruby-forum.com/.--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---