I'm puzzled. Maybe someone else has an idea.
What happens if you run the same app on your local machine with SQLite?
On Tuesday, October 18, 2011 1:17:54 PM UTC-4, Sathvik Ponangi wrote:
>
> Yes, I'm always calling it with:
>
> fetchText('changeThis.txt')
>
>
> On Tue, Oct 18, 2011 at 10:40 PM, Anthony <[email protected]> wrote:
>
>> How are you calling fetchText? Are you sure the value you are passing as
>> the 'name' argument is in fact the value of the 'hash' field of one of the
>> records?
>>
>>
>> On Tuesday, October 18, 2011 12:16:09 PM UTC-4, Sathvik Ponangi wrote:
>>
>>> Dear Johann,
>>> I'm using Web2py with Google AppEngine & I can see that the rows have
>>> the required value on the DataStore Viewer (on the SDK console). Here is
>>> the
>>> snippet I'm using:
>>>
>>> def fetchText(name):
>>>
>>> textobj = db(db.files.hash==name).**select().last()
>>>
>>> if not textobj:
>>>
>>> textobj_id = db.files.insert(hash=name, name=name, path=name,
>>>> text="")
>>>
>>> textobj = db.files[textobj_id]
>>>
>>>
>>> Thank you for your attention.
>>>
>>> With Regards,
>>> Sathvik
>>>
>>>
>>>
>>> On Tue, Oct 18, 2011 at 5:29 PM, Johann Spies <[email protected]> wrote:
>>>
>>> On 18 October 2011 13:20, Sathvik Ponangi <[email protected]> wrote:
>>>>
>>>>> db(db.files.hash==name).**select().first() always gives None, what's
>>>>> the right way to do it?
>>>>>
>>>>> Thanks for your help...
>>>>>
>>>>
>>>> .first() will only work if len(db(db.files.hash==name).**select()) > 0
>>>>
>>>> If you get None it means that the query did not find anything. If the
>>>> query find something the length of the result will be >=1
>>>>
>>>> Regards
>>>> Johann
>>>>
>>>> --
>>>> Because experiencing your loyal love is better than life itself,
>>>> my lips will praise you. (Psalm 63:3)
>>>>
>>>>
>>>
>>>
>>> --
>>> Sathvik Ponangi
>>>
>>
>
>
> --
> Sathvik Ponangi
>
