trying to change select() with iterselect() on all of my code, some work
and some not work.
in select() can check if len(rows_2) > 0: on the other side iterselect() if
rows_2:
*error traceback*
Traceback (most recent call last):
File "/Users/MacBookPro/site/web2py/gluon/restricted.py", line 227, in
restricted
exec ccode in environment
File
"/Users/MacBookPro/site/web2py/applications/mutualfunds/views/report/report_currency.html",
line 109, in <module>
File "/Users/MacBookPro/site/web2py/gluon/packages/dal/pydal/objects.py",
line 2761, in __iter__
row = next(self)
File "/Users/MacBookPro/site/web2py/gluon/packages/dal/pydal/objects.py",
line 2739, in __next__
db_row = self.cursor.fetchone()
ProgrammingError: Cannot operate on a closed cursor.
*the code in file generated around line 109 is marked bold red color :*
for row_pie in rows_2:
response
<http://127.0.0.1:8000/examples/global/vars/response>.write("\r\n
['", escape=False)
response <http://127.0.0.1:8000/examples/global/vars/response>.write(T
<http://127.0.0.1:8000/examples/global/vars/T>(row_pie.product.name))
response
<http://127.0.0.1:8000/examples/global/vars/response>.write("', ", escape=False)
response
<http://127.0.0.1:8000/examples/global/vars/response>.write(row_pie.subscription_amount)
response <http://127.0.0.1:8000/examples/global/vars/response>.write('
],\r\n ', escape=False)
pass
response <http://127.0.0.1:8000/examples/global/vars/response>.write("\r\n
]\r\n }],\r\n title: {\r\n
text: '", escape=False)
response <http://127.0.0.1:8000/examples/global/vars/response>.write(T
<http://127.0.0.1:8000/examples/global/vars/T>('Subscription'))
response
<http://127.0.0.1:8000/examples/global/vars/response>.write('\'\r\n
},\r\n tooltip: {\r\n pointFormat: \'<span
style="color:{point.color}">{series.name} : <b>Rp. {point.y:,.2f}
({point.percentage:.1f} %)</b><br/>\'\r\n }\r\n });\r\n
\r\n // pie balance\r\n $(\'#pie_balance\').highcharts({\r\n
credits: {\r\n enabled: false\r\n },\r\n
plotOptions: {\r\n pie: {\r\n
allowPointSelect: true,\r\n cursor: \'pointer\',\r\n
dataLabels: {\r\n enabled: true, \r\n
format: \'<b>{point.name}</b> :<br />Rp. {point.y:,.2f}<br
/>{point.percentage:.1f} %\'\r\n },\r\n
showInLegend: true\r\n }\r\n },\r\n
series: [{\r\n type: \'pie\',\r\n name: \'',
escape=False)
response <http://127.0.0.1:8000/examples/global/vars/response>.write(T
<http://127.0.0.1:8000/examples/global/vars/T>('Balance'))
response <http://127.0.0.1:8000/examples/global/vars/response>.write("
',\r\n data: [\r\n ", escape=False)
*for row_pie in rows_2: *response
<http://127.0.0.1:8000/examples/global/vars/response>.write("\r\n
['", escape=False)
response <http://127.0.0.1:8000/examples/global/vars/response>.write(T
<http://127.0.0.1:8000/examples/global/vars/T>(row_pie.product.name))
response
<http://127.0.0.1:8000/examples/global/vars/response>.write("', ", escape=False)
response
<http://127.0.0.1:8000/examples/global/vars/response>.write(row_pie.balance)
response <http://127.0.0.1:8000/examples/global/vars/response>.write('
],\r\n ', escape=False)
pass
response <http://127.0.0.1:8000/examples/global/vars/response>.write("\r\n
]\r\n }],\r\n title: {\r\n
text: '", escape=False)
response <http://127.0.0.1:8000/examples/global/vars/response>.write(T
<http://127.0.0.1:8000/examples/global/vars/T>('Balance'))
response
<http://127.0.0.1:8000/examples/global/vars/response>.write('\'\r\n
},\r\n tooltip: {\r\n pointFormat: \'<span
style="color:{point.color}">{series.name} : <b>Rp. {point.y:,.2f}
({point.percentage:.1f} %)</b><br/>\'\r\n }\r\n
});\r\n\t\t\r\n // pie profit_loss_value\r\n
$(\'#pie_profit_loss_value\').highcharts({\r\n credits: {\r\n
enabled: false\r\n },\r\n plotOptions: {\r\n
pie: {\r\n allowPointSelect: true,\r\n
cursor: \'pointer\',\r\n dataLabels: {\r\n
enabled: true, \r\n format:
\'<b>{point.name}</b> :<br />Rp. {point.y:,.2f}<br />{point.percentage:.1f}
%\'\r\n },\r\n showInLegend: true\r\n
}\r\n },\r\n series: [{\r\n
type: \'pie\',\r\n name: \'', escape=False)
response <http://127.0.0.1:8000/examples/global/vars/response>.write(T
<http://127.0.0.1:8000/examples/global/vars/T>('Profit/Loss'))
response <http://127.0.0.1:8000/examples/global/vars/response>.write("
',\r\n data: [\r\n ", escape=False)
for row_pie in rows_2:
profit_loss_value = row_pie.balance - row_pie.subscription_amount
if profit_loss_value > 0:
response
<http://127.0.0.1:8000/examples/global/vars/response>.write("\r\n
['", escape=False)
response
<http://127.0.0.1:8000/examples/global/vars/response>.write(T
<http://127.0.0.1:8000/examples/global/vars/T>(row_pie.product.name))
response
<http://127.0.0.1:8000/examples/global/vars/response>.write("', ", escape=False)
response
<http://127.0.0.1:8000/examples/global/vars/response>.write(profit_loss_value)
response
<http://127.0.0.1:8000/examples/global/vars/response>.write(' ],\r\n
', escape=False)
pass
response
<http://127.0.0.1:8000/examples/global/vars/response>.write('\r\n
', escape=False)
pass
is it normal or did i missed something?
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.
