rendered paste body>>> import boto
>>> c = boto.connect_sdb()
>>> d = c.get_domain('mydomain')
>>> d.query("['item_id' = '293760']")
<generator object at 0xce13f0>
>>> _.next()
{u'item_id': u'293760', u'timestamp': u'2009-05-07T12:45:20', ...}
>>> d.select('select * from mydomain where `item_id`="293760"')
<generator object at 0xce13f0>
>>> _.next()
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/Library/Frameworks/Python.framework/Versions/2.5/lib/python2.5/site-packages/boto-1.7a-py2.5.egg/boto/sdb/queryresultset.py", line 55, in select_lister
rs = domain.connection.select(domain, query, next_token=next_token)
File "/Library/Frameworks/Python.framework/Versions/2.5/lib/python2.5/site-packages/boto-1.7a-py2.5.egg/boto/sdb/connection.py", line 419, in select
return self.get_list('Select', params, [('Item', Item)], parent=domain)
File "/Library/Frameworks/Python.framework/Versions/2.5/lib/python2.5/site-packages/boto-1.7a-py2.5.egg/boto/connection.py", line 532, in get_list
raise self.ResponseError(response.status, response.reason, body)
boto.exception.SDBResponseError: SDBResponseError: 400 Bad Request
<?xml version="1.0"?>
<Response><Errors><Error><Code>InvalidQueryExpression</Code><Message>The specified query expression syntax is not valid.</Message><BoxUsage>0.0000137200</BoxUsage></Error></Errors><RequestID>7c889cc7-afe0-8b3a-ac0d-a4689ba92780</RequestID></Response>