Re: [Rails] Search form AND condition - Not working

On 7 May 2013 13:17, tamouse mailing lists <tamouse.lists@gmail.com> wrote:
> On Tue, May 7, 2013 at 1:08 AM, Maddy <ashokkumar@shriramits.com> wrote:
>> Hi Folks,
>>
>> My search fields,
>>
>> Firstname*
>> Lastname*
>> MI - Middle initial
>> State*
>> ID
>> Birthday
>>
>> when people will search John Bolton in any state for example AL (Alabama),
>> all John Bolton names in only AL will show up.
>> So if there are 3 John Bolton with different middle MIs, they will show, for
>> example
>> John A. Bolton
>> John W. Bolton
>> John O. Bolton and so on...
>>
>> I used this code in my model, But it show an error,
>>
>> def
>> self.search_my_new_contact(first_name,last_name,initial,inimate_id,state,dob)
>> find(:all, :include=>[:address_book], :conditions => ["'( LOWER
>> (address_books.first_name) LIKE ? AND LOWER (address_books.last_name) LIKE ?
>> AND LOWER (address_books.state_name) LIKE ?)' AND '(LOWER
>> (address_books.initial) LIKE ? OR LOWER (address_books.inmate_id_number)
>> LIKE ? OR LOWER (address_books.birthday) LIKE ?)'",
>> "#{first_name.downcase}","#{last_name.downcase}","#{initial.downcase}",
>> "#{inimate_id.downcase}", "#{state.downcase}","#{dob.downcase}"])
>> end
>>
>> ActiveRecord::StatementInvalid in InimateLocatorsController#index
>> ...
> MySQL is complaining about the double dot in this section:
>
> WHERE ( ( LOWER (address_books.first_name) LIKE 'remo' AND LOWER
> (address_books.last_name)
> LIKE 'nandi' AND LOWER (address_books..state_name) LIKE 'ar'))
>
>
> But I don't see how it's getting that from your code:
>
> '( LOWER (address_books.first_name) LIKE ? AND LOWER
> (address_books.last_name) LIKE ? AND LOWER (address_books.state_name)
> LIKE ?)'
>
> I only see a single dot in address_books.state_name so I'm really not
> sure where the problem stems from...

I wonder whether there is a non-printing character in the source code
"LOWER (address_books.state_name)" which is appearing as the extra dot
in the sql. Try deleting and re-typing that bit to see if it makes a
difference. That is of course if you have not already realised that
the code you posted is not actually the code in the source file.

Colin

>
> --
> You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
> To post to this group, send email to rubyonrails-talk@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.