formfields.com

[themicah]

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 '110,111,112,pre113,113,114,115,115a,116,117,118,119,120,121,121a:
INSERT INTO questionnaire_part2 (110,111,112,pre113,113,114,115,115a,116,117,118,119,120,121,121a,122,122a,pre123,123,124,124a,125,125a,125b,126,126a,126b,126c,126d,126e,126f,126g,126h,127,__inserted_on) VALUES (null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'2006-10-09 00:09')

//This comes up when I try to sumbit on one of my forms.

[formfields]

This is occuring because you appeared to have generated a form using FORMgen that contains field names that start with a number. Field names like 110, 111, etc.. cause problems in MySQL. In a future release of FORMgen, we will disable this ability and force one to start all field names with a letter. For now, you should edit your form in FORMgen and change each field name so that it starts with a letter. For example, 110 could become field110 or 111 could become f111. After you have changed all the fields, you should reupload your form and new database scripts. You should also run the new database scripts so that your old table is replaced.