[web2py] manual for loop in views and json

[黄祥]

let say i have a code with web2py in highchart, when i tried to convert it 
data using json, it's not work
*previous code works well using python in views manually *
*views/templates/chart_pie.html*
            series: [{
                type: 'pie',
                name: '{{=T('Subscription') }} ',
                data: [
                {{for row_pie_subscription in rows_2:}}
                    ['{{=T(row_pie_subscription.product.name) }}', 
{{=row_pie_subscription.subscription_amount}} ],
                {{pass}}
                ]
            }],

*# 1 - trying using service not work, no error occured, the result is not 
expected (repeated data on subscription)*
*controllers/default.py*
import json

@service.json
def test():
    query = (db.account.investor == 1)
    rows = db(query).select(orderby = ~db.account.id)
    return json.dumps([[r.product.name, r.subscription_amount] for r in 
rows] )
    #return dict(rows = rows)

*views/templates/chart_pie.html*
        $.getJSON('http://127.0.0.1:8000/test/default/call/json/test', 
function (data) {

            // pie subscription
            $('#pie_subscription').highcharts({
                ...
                series: [{
                    type: 'pie',
                    name: '{{=T('Subscription') }} ',
                    data: data
                }],
                ...
            });

        });

*trying to test manually http://127.0.0.1:8000/test/default/call/json/test*
"[[\"MNC Dana Ekuitas\", 1.0], [\"MNC Dana Likuid\", 2.0], [\"MNC Dana 
Lancar\", 3.0]]"

*# 2 - trying json dumps in view not work, no error occured, the result is 
not expected (no chart pie at all)*
*views/templates/chart_pie.htm*l
            series: [{
                type: 'pie',
                name: '{{=T('Subscription') }} ',
                data: 
                {{
                import json
                json.dumps([[r.product.name, r.subscription_amount] for r 
in rows] )
                }}
            }],

is it possible 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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.