Hello, Why don't you try:
@facturas = Facturas.find(:all, :conditions => [ "numeracion like ? or orden_servicio like ?",'%...@q}%','%...@q}%']) Using a ? in your sql statement should protect you from some sql injection attacks. Also, it seems it would be cross database compatible. I did not try this out, so let me know if it doesn't work for you. http://api.rubyonrails.org/classes/ActiveRecord/Base.html#M002213 (both the exists? example and the find example) Buenas Suerte, Keenan On Feb 2, 2009, at 11:18 PM, lonecat wrote: > > This is the search string i'm using now: > @facturas = Factura.find_by_sql("SELECT * FROM facturas WHERE > numeracion like '%...@q}%' OR orden_servicio like '%...@q}%'; ") > > Now, I've never actually worked with sql queries but that does the > right job on my laptop. Is it wrong for postgresql? > > On Feb 2, 12:02 pm, lonecat <jfgome...@gmail.com> wrote: >> Thanks for your reply Keenan, >> I forgot to mention the password: username: avanza password: avanza. >> Doing heroku logs gives me this:http://pastie.org/377143 >> Good you mentioned that heroku uses postgreSQL. I'm using rail's >> default Sqlite3. Maybe it's a query problem then. >> How could I get a stack trace? >> I also tried creating a test application, different heroku name, same >> local app (which works here) but got the same results, so I'm >> thinking >> maybe it's definetly a query problem. >> How could I restart my app in Development mode so I can see some more >> info? >> >> On Feb 2, 8:31 am, Keenan Brock <kee...@thebrocks.net> wrote: >> >>> Hi, >> >>> I can't get past the password prompt. >> >>> Could you describe what "doesn't work" means? >> >>> a) data is not showing up? >>> b) stack trace? >>> c) other? >> >>> quick solutions: >>> a) If no data is showing up, you want to dump your database and >>> upload >>> the yml >>> b) If the query is bad, then you may want to be aware that it is >>> running postgreSQL. >> >>> Please share a little more about the problem and we will do our best >>> to assist you. >> >>> --Keenan >> >>> On Feb 2, 2009, at 3:23 AM, lonecat wrote: >> >>>> Hi, a page in my app doesn't work in heroku although it does work >>>> in >>>> my laptop. It seems to be (possibly) a database problem, but i'm >>>> not >>>> sure. I just wanted to know how can i get heroku's sqlite3's >>>> version >>>> and why doesn't it let me do heroku rake db:drop. >> >>>> If anyone is willing to help me, please look here: >>>> http://avanza-facturas.heroku.com/facturas/findtryto type something >>>> in the searchbox or click "Mostrar Todo". > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to heroku@googlegroups.com To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/heroku?hl=en -~----------~----~----~----~------~----~------~--~---
