thanks for your hints, Marlysson, but the format is not same like
highcharts needs
*format needed :*
data: *[ *
* ['Dana Ekuitas', 1.0 ],*
* ['Dana Likuid', 2.0 ],*
* ['Dana Lancar', 3.0 ],*
*]*
*my code :controllers/default.py*
@service.json
def my_data():
query = (db.account.investor == 1)
rows = db(query).select(db.account.product.name,
db.account.subscription_amount, orderby = ~db.account.id)
#return json.dumps([[r.product.name, r.subscription_amount] for r in
rows] ) *# not worked no error occured because it's return string*
#return response.json([[r.product, r.subscription_amount] for r in
rows] ) *# not worked error traceback : raise AttributeError*
#your_data = rows.as_dict()
#your_data = rows.first().as_dict()
your_data = rows.as_list()
return response.json(your_data) *# not worked the format it's not
expected must been in bracket [ [] ] like in format needed above*
any idea how to achieve it using web2py way?
thanks and best regards,
stifan
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
