Try change the response content-type, see below:
On Sun, Nov 3, 2013 at 6:28 AM, Mihir Lade <[email protected]> wrote: > hi, > > i have a function in a controller which queries the database if the user > is logged in and then grabs the information using json (as below) > > def pruchaseHistoryJson(): > if auth.user: > rows = db(db.sale.auth_id == auth.user.id > ).select(db.sale.title, > db.sale.price, > db.sale.shipping_address, > db.sale.shipping_state, > db.sale.shipping_city, > db.sale.shipping_zip_code) > else: > redirect(URL('default', 'user/login')) > > response.headers['Content-Type'] = 'application/json' > import gluon.contrib.simplejson as json > prodHistory = json.dumps([{'name': i.title, > 'prodValue':i.price, > 'shipAdd':i.shipping_address, > 'shipCity':i.shipping_city, > 'shipState':i.shipping_state, > 'shipCode':i.shipping_zip_code} for i in > rows]) > return prodHistory > > Also note that json top level arrays are not recommended: http://haacked.com/archive/2009/06/25/json-hijacking.aspx http://security.stackexchange.com/questions/7001/how-should-web-app-developers-defend-against-json-hijacking -- 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/groups/opt_out.
