ah i changed a bit much :
here is the new code (the problem fixed there)
def get_items():
response.generic_patterns = ['json']
query=(db.item.id>0)
items=db(query).select(db.item.id,db.item.name)
return response.json(items)
On 11/2/11, Phyo Arkar <[email protected]> wrote:
> the model is :
>
> db.define_table("item",
> SQLField("name", "text", length=512, notnull=True, default=None),
> SQLField("base_price", "integer", notnull=True, default=None),
> SQLField("price", "integer", notnull=True, default=None)
> )
>
>
> """
> Table definition
> """
> from datetime import date
> import time
>
> db.define_table("sale",
> SQLField("id_items", db.item),
> SQLField("date", "date", notnull=True, default=date.today()),
> SQLField("sale_time", "datetime", notnull=True, default=request.now),
> SQLField("total_items", "integer", notnull=True, default=None),
> SQLField("description", "text", notnull=False, default=None))
>
>
> it was fixed now after i changed >=0 into >0 .
>
> On 11/1/11, Massimo Di Pierro <[email protected]> wrote:
>> Sorry for my late reply.
>>
>> You do not need response.generic_patterns = ['json'] as the generic view
>> is
>> not used when you return a string.
>>
>> The error is a serialization error. What's in the model?
>>
>>
>>
>>
>> On Oct 23, 2011, at 12:20 PM, Phyo Arkar wrote:
>>
>>> def get_items():
>>> response.generic_patterns = ['json']
>>> query=(db.item.id>=0)
>>> return response.json(db(query).select(db.item.id,db.item.name))
>>
>>
>
