Forums

Adding fields to table results in no redirect and no submis

OpenEyeMedia 25 Jan, 2010
Hi there,
When associating a table to a form and selecting to write to the table, all is fine if I select only the default fields when creating the table. On form submission the redirect occurs, and a record is created in the database table.

If however I add the fields associated to the various elements of my form to the database table, when a form is submitted it does not redirect, instead I get a white screen, and while the emails are sent successfully, no information gets written to the database table.

Can anyone shed some light as to what the issue might be? If additional info is required, please let me know.

Thanks in advance,
Chris
GreyHead 25 Jan, 2010
Hi Chris,

Most likely you have a 'dash', space, or some other special character in one or more of your input names and it is breaking the SQL. Hard to say any more without seeing the Form HTML.

How are you adding the form element columns to the database table?

Bob
OpenEyeMedia 25 Jan, 2010
Hi there,
Thanks for getting back to me so quickly - that was indeed the reason for it. I discovered it when I tried to manually add the fields via 'Manage Tables'.
Thanks again.
Chris
This topic is locked and no more replies can be posted.