Python appengine Query does not work when using a variable.
Posted
by Lloyd
on Stack Overflow
See other posts from Stack Overflow
or by Lloyd
Published on 2010-03-11T19:34:25Z
Indexed on
2010/03/11
19:39 UTC
Read the original article
Hit count: 246
Hi, I am trying to use a fetcher method to retrieve items from my datastore. If I use the following
def getItem(item_id):
q = Item.all()
q.filter("itemid = ", item_id)
It fails because nothing is returned. If I hard code in an item like
def getItem(item_id):
q = Item.all()
q.filter("itemid = ", 9000)
it fetches just fine, and sings merrily along. I have tried every which way to get this to work. I have used
result = db.GqlQuery("SELECT * FROM Item WHERE item_id = :1 LIMIT 1",
title).fetch(1)
to the same effect. If I hard code in a number, works fine. I have tried setting the select statement as a local string, assembling it that way, casting the int as a string, and nothing. When I output the SELECT statement to the screen, looks fine. I can cut ans paste the output into the string, and whammo, it works. Any help would be appreciated.
© Stack Overflow or respective owner