Are you using MySQL to develop locally instead of Postgres? MySQL considers LIKE case insensitive, you need to use ILIKE on postgresql to get the same behavior.
-Nick On Tue, Jan 26, 2010 at 10:20 AM, Sunny Beach <[email protected]>wrote: > I have narrowed down the problem to capitalization. If the query > string matches up (exactly) then all is well. > > BAD: > http://content-tracker.heroku.com/program_names.js?q=inter > > GOOD: (finds three "International..." programs) > http://content-tracker.heroku.com/program_names.js?q=Inter > > I have not been able to figure out how to fix this. > > You can see the full list of programs (only 20 currently): > http://content-tracker.heroku.com/program_names.js > > Sunny > > > On Jan 25, 11:20 pm, Sunny Beach <[email protected]> wrote: > > I have a small app that has a single Jquery Autocomplete field. It > > seems very slow and spotty (not returning all the results it should) > > on Heroku. It does work but not very well. > > > > Is this due to the differences in databases between here and Heroku? > > The call for the autocomplete is: > > ProgramName.find(:all, :conditions => ['name LIKE ?', "%#{params[:q]}%"]) > > > > Is it due to a query limit (I am the only person using it at the moment). > > > > Any ideas? > > > > Thanks, > > Sunny > > -- > You received this message because you are subscribed to the Google Groups > "Heroku" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<heroku%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/heroku?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
