Many thanks, that seems to make everything work! Sunny
ps. yes, I should be using postgres locally. On Tue, Jan 26, 2010 at 10:23 AM, Nick Quaranto <[email protected]> wrote: > 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]. >> 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. > -- 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.
