HI All,
I am up against the wall as far as time is concerned, I have promised I
will get the images for his updated products on his site by end of play
today and this is the first time I have used web2py to automate most of the
process.
I am getting this error
<type 'exceptions.TypeError'>('Set' object is not iterable)
Here is the offending piece of code.
query3 = cmdb(cmdb.executesql("select image.id_product, image.id_image,
product.reference from image join product on product.id_product =
image.id_product"))
for row in query3:
image_list_file.write(row.id_product + "," + row.id_image + "," +row
.reference + "\n")
and here is the full Traceback
TRACEBACK
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
Traceback (most recent call last):
File "/home/simon/web2py/gluon/restricted.py", line 205, in restricted
exec ccode in environment
File "/home/simon/web2py/applications/update_vitaldb/controllers/vital.py"
<http://localhost:8000/admin/default/edit/update_vitaldb/controllers/vital.py>,
line 133, in <module>
File "/home/simon/web2py/gluon/globals.py", line 173, in <lambda>
self._caller = lambda f: f()
File "/home/simon/web2py/applications/update_vitaldb/controllers/vital.py"
<http://localhost:8000/admin/default/edit/update_vitaldb/controllers/vital.py>,
line 130, in image_database_prep
for row in query3:
TypeError: 'Set' object is not iterable
Any help would be much appreciated.
Thanks
Simon
--
