I'm not completely sure why, but fixing the encoding of show of my pages seemed to fix the issue. It's a bit weird, but it work beautiful now.
-- Simon On Nov 13, 5:06 pm, Leon Waldman <[email protected]> wrote: > Hi, > > I'm not sure if this is the case, but I think this is a issue on python it > self and not on web.py. > > I'm saying that because I have some set of scripts (No Web.py related) that > hang when fetching data from a Database (MySQL) that contains the ' > character. (And some others too like "("or ")"). > > Unfortunately i'm totally out of time to debug my scripts (And till now is > making more sense to just open navicat and remove this occurrences when they > happens). > > Which kind of DB Connector WebPy is using? (Or it lets you to choose? I > Never used DB with my webpy apps till now)... > > Cheers > > -- > Leon Waldman > SysAdmin Linux - Arquiteto de Infra-Estrutura & TI. > > > > On Fri, Nov 13, 2009 at 11:18 AM, Simon <[email protected]> wrote: > > > Hi, > > > I'm having a hard time figuring out the correct way of doing the > > following: > > > In my database (SQLite), I have a "title" column, which is just a text > > field. One entry have a ' in it, example: It's pretty annoying > > > When I try to do the following, it fails, due to the ' in title > > param= dict(title=title) > > results = db.select('shows', param, where="title= $title") > > > I thought the solution was in Web.db.SQLParam or sqlquote, but they > > convert 'it's annoying' to '"It's annoying"', which also fails, > > because the database entry doesn't have the " in it. Or at least > > that's what I think is happening. > > > The one solution I did find was: > > > title = title.replace('\\', '\\\\') > > param= dict(title=title) > > results = db.select('shows', param, where="title= $title" > > > That not as pretty as I would like and I'm a bit concerned that it's > > not always going to work or even be safe. > > > Are there any better solutions using the webpy db functionality? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web.py" 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/webpy?hl=en -~----------~----~----~----~------~----~------~--~---
