Thanks for your response Marzia. This was my mistake.
Problem was when I take a value from the url that has an apostrophe, it replaces the apostrophe with %27. All good now, until the next time. On Mar 19, 1:49 pm, Marzia Niccolai <[email protected]> wrote: > Hi, > > More information is needed, this works as expected for me: > class TestPage(webapp.RequestHandler): > def get(self): > model = TestModel(mystring="hello's") > model.put() > > retr = db.GqlQuery("SELECT * FROM TestModel WHERE mystring = :1", > "hello's").get() > self.response.out.write(retr.mystring) > > -Marzia > > > > On Thu, Mar 19, 2009 at 5:07 AM, WallyDD <[email protected]> wrote: > > > Hi, > > I have some strings which I have no trouble storing and retrieving > > from the table. > > > The problem is querying the string with an apostrophe. > > > I am using the command; > > x = db.GqlQuery("SELECT * FROM sometable where x = :1 AND y =:2 AND z > > =:3",a,b,c) > > at this stage it is z with the string that contains the apostrophe. > > > It works fine with all other data without an apostrophe. > > > Any ideas? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" 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/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---
