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 <[email protected]> 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 <[email protected]> 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 [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 -~----------~----~----~----~------~----~------~--~---
