SortHelper problem


#1

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!


#2

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


#3

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 N. removed_email_address@domain.invalid


#4

Chuck V. 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/SortHelper2

Yes, i have tried that. Unfortunately the mail gets bounced back.

Fortunately i’ve found an alternative. Thanks anyway.