I am trying to allow for AND type ‘find’ but to allow for simply a
single set of find criteria.
controller code…
@vw_string = @vw_string1 = @vw_string2 = @vw_string3 = []
if params[:beg_intake_date] != "" then
@vw_string1 = ["intake_date between ? and ?",
params[:beg_intake_date], params[:end_intake_date] ]
end
if params[:beg_referral_date] != "" then
@vw_string2 = ["referral_date between ? and ?",
params[:beg_referral_date], params[:end_referral_date] ]
end
if params[:beg_discharge_date] != "" then
@vw_string3 = ["discharge_date between ? and ?",
params[:beg_discharge_date], params[:end_discharge_date] ]
end
-> @vw_string = [@vw_string1, @vw_string2, @vw_string3]
@placement_pages, @placements = paginate(
:placements,
:conditions => @vw_string,
:include => [:client, :case_manager, :facility],
:order_by => 'referral_date',
:per_page => 14)
The above setup gives me an error 'undefined method '%" for []:Array
Same thing if I set…
@vw_string = @vw_string1, @vw_string2, @vw_string3
and if I do it like this…
@vw_string = [@vw_string1] [@vw_string2] [@vw_string3]
I get can’t convert Array into Integer
How can I get the @vw_string into something that allows for ‘AND’
conditions or singular conditions if only 1 criteria resulted from a
search?
Craig