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 --