ecart store details in database

Please ignore the below. I used a reserved word "add" as a database field name. Corrected this and all now good. Mupet....

Hi Guys, I edited the ecart store details in database behaviour on the confirm page to bind my products to the database fields I added to the order detail page. I now get the below when on the confirm page. I cant see the problem. Would the option / field name "add" be reserved by any chance? Thaks in advance. Jon

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'add,cylinder,axis) values (2,0,'Acuvue Tru Eye (30 Per Box)',30,1,'8.5','14.2','' at line 1

yes, Add is a reserved word in My SQL:

http://dev.mysql.com/doc/mysqld-version-reference/en/mysqld-version-reference-reservedwords-5-5.html

using that as a column name is causing the error.

Thanks Jason. On a related issue. I found the tutorial on dynamic product options difficult to follow. Perhaps I need to read it a few times. Are there any other guides other than the two tutorials found in the ecart section.

These are all the tutorial that we offer that deal with product options in eCart:

http://www.webassist.com/tutorials/Product-Options-with-eCart

http://www.webassist.com/tutorials/Add-static-product-options-eCommerce-Series

http://www.webassist.com/tutorials/Add-dynamic-product-options-I-eCommerce-Series

http://www.webassist.com/tutorials/Add-dynamic-product-options-II-eCommerce-Series