in the source given, i see something like
* :conditions => ["'( LOWER (*
*(address_books.birthday) LIKE ?)'", **
*
*
*
is theres a extra quote?
2013/5/7 Colin Law <clan...@googlemail.com>
> On 7 May 2013 13:17, tamouse mailing lists <tamouse.li...@gmail.com>
> wrote:
> > On Tue, May 7, 2013 at 1:08 AM, Maddy <ashokku...@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+unsubscr...@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+unsubscr...@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+unsubscr...@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.
