hi priya,
i ahve tried the same way,but i am getting errors like:
ActiveRecord::StatementInvalid in StreamsController#get_results
Mysql::Error: Column 'name' in where clause is ambiguous: SELECT
streams.name FROM `streams` streams inner join tags as t on
streams.id=t.id WHERE (name LIKE '%mpeg2%' or resolution LIKE
'%mpeg2%' or
codecname LIKE '%mpeg2%' or framerate LIKE '%mpeg2%' or tags LIKE
'%mpeg2%' or t.name LIKE '%mpeg2%')
can you tell me ,where is the problem?
regards
Srikanth
On Wed, Dec 10, 2008 at 6:02 PM, Priya Buvan
<[EMAIL PROTECTED]> wrote:
>
> @stream = Stream.find(:all, :joins => "streams inner join tags as t on
> streams.id=t.id", :conditions => ['name LIKE ? or resolution LIKE ? or
> codecname LIKE ? or framerate LIKE ? or tags LIKE ? or t.name LIKE ?',
> '%'+params[:search_text]+'%','%'+params[:search_text]+'%','%'+params[:search_text]+'%',
> '%'+params[:search_text]+'%','%'+params[:search_text]+'%','%'+params[:search_text]+'%'],
> :select => "steams.name")
>
>
> just try with this. I think it'll work.
> --
> 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@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
