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))
>
>
