Hi Nick,
The % syntax works. Here is an example that I am using:
"%%%s%" % @params[:query]
There may be a better way to do the above... but to explain it:
the first two % resolve to a single % wildcard (I needed to escape it
since there is another %s that will get messed up if you don''t
explicitly escape this wildcard).
The %s is for the string to insert.
The last % is just for a trailing wildcard.
This should also work for the empty case, so when the page first
loads, it would match everything because the match string resolves to
"%%".
Tom
On 9/27/05, Nick <brutyn_nick-PkbjNfxxIARBDgjK7y7TUQ@public.gmane.org>
wrote:>
>
> hey, i want to created an sql statement with rails for a search engine
>
> this is the code, u can search on first name and last name
>
> firm_id = @session[:user].id
> #last_name = params[:employee][:last_name]
> #first_name = params[:employee][:first_name]
> last_name = "Creytens"
> first_name = "b"
> @employee_pages, @employees = paginate (:employee, :conditions =>
> ["firm_id = ? and first_name like ? and last_name like ?" ,
firm_id,
> first_name, last_name] , :order_by => "last_name ASC",
:per_page => 10)
>
>
> i have a few question:
>
> -how can i make, that the user doesnt need to fill in the full name, just
> 1st or a couple of letters, in php i can use the % ==>
''%first_name%'', seems
> not to work here
>
> -the search engine is on the same page as the results, but the first time
> the parameters arent there, so i just want to show all employees, if the
> parameters are there then i show those.
> How can i check if the parameters are there, in php u can u isset(
> *_POST["last_name"] ), what is that here?
> _______________________________________________
> Rails mailing list
> Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>
>
>