I think I am encountering a bug on parse_sort_param.
Somewhere along the way when it generates the SQL, it is not putting a
space between the ORDER BY field and the asc command.
With this @location_products assignment,
@location_products = @location_products.scoped(:include
=> :product, :conditions => ['products.name LIKE ?',
"%#{params[:search]}%"], :order => parse_sort_param("product.name",
"product.code", :current, :minimum, :restock_to ))
if I click on the "minimum" column (or any other column) for a sort, I
get this error:
SQLite3::SQLException: no such column: minimumasc:
and the last bit of the generated SQL is ORDER BY minimumasc
Tried this as a workaround:
if !params[:sort].blank?
params[:sort] = params[:sort] + " "
end
That gets rid of the error but it isn't sorting at all.
I have to leave for the day but will pick this up again in the
morning.
Thanks,
Brian
On Feb 8, 5:55 pm, Brian Corbin <[email protected]> wrote:
> Oh you're good.. you're good.. I'm going to figure out how .scoped
> works now and get my sort on!
>
> Thanks Matt!
>
> On Feb 8, 5:49 pm, Brian Corbin <[email protected]> wrote:
>
>
>
> > Okay this is better:
>
> > @location_products =
> > @location.location_products.find(:all, :conditions => ["product_id in
> > (select id from products where name like ?)","%" + params[:search] +
> > "%"]) unless params[:search].nil?
>
> > On Feb 8, 5:44 pm, Brian Corbin <[email protected]> wrote:
>
> > > Ack that's no good as it introduces a SQL injection attack vector :(
>
> > > On Feb 8, 5:35 pm, Brian Corbin <[email protected]> wrote:
>
> > > > I think I have search working by doing this:
> > > > �...@location_products = @location.location_products unless !
> > > > params[:search].nil?
> > > > �...@location_products =
> > > > @location.location_products.find(:all, :conditions => "product_id in
> > > > (select id from products where name like '%" + params[:search] +
> > > > "%')") unless params[:search].nil?
>
> > > > Working on sort now...
>
> > > > On Feb 8, 4:21 pm, Brian Corbin <[email protected]> wrote:
>
> > > > > My apologies for yet another thread on table-plus, but I didn't see
> > > > > the answer for this particular problem. I'm trying to enable sorting
> > > > > and searching for a table-plus tag on the show controller of my
> > > > > Location model. The goal is to be able to view the Products stored at
> > > > > a Location
>
> > > > > In locations\show.dryml:
> > > > > <table-plus with="&@location_products" fields="product.name,
> > > > > product.code, current, minimum, restock_to">
>
> > > > > In controllers\locations_controller.rb:
> > > > > def show
> > > > > �...@location = find_instance
> > > > > �...@location_products =
> > > > > �[email protected]_products.apply_scopes(:search =>
> > > > > [params[:search], ???What goes here??? ],
> > > > > :order_by => parse_sort_param(???
> > > > > What goes here???, :current, :minimum, :restock_to))
>
> > > > > end
>
> > > > > So the question is how do I allow searching and sorting on
> > > > > product.name and/or product.code?
>
> > > > > Here are the relationships (pseudo-code):
> > > > > Location has_many :products, :through => :location_products,
> > > > > has_many :location_products
> > > > > Product has_many :location_products, has_many :locations, :through
> > > > > => :location_products, :accessible => true
> > > > > location_products belongs_to :location, belongs_to :product
>
> > > > > Thanks in advance!
--
You received this message because you are subscribed to the Google Groups "Hobo
Users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/hobousers?hl=en.
