Hello. I have created a form called "LEND" and it seems to work fine on my site. All of the fields work and the form submits fine. The problem comes when I try to create a database table to store the information that is submitted.
When I try to save the table, I get this error.
[attachment=0]Screen Shot 2012-04-14 at 10.07.29 PM.png[/attachment]
I am fairly new to this, so I'm sure it is user error. haha.
Any help will be greatly appreciated.
When I try to save the table, I get this error.
[attachment=0]Screen Shot 2012-04-14 at 10.07.29 PM.png[/attachment]
I am fairly new to this, so I'm sure it is user error. haha.
Any help will be greatly appreciated.
Hi deezgrafix,
There's a comma after the last VARCHAR(35) that probably shouldn't be there. You may be deleting the Submit Button name and type but are not unchecking it?
Bob
There's a comma after the last VARCHAR(35) that probably shouldn't be there. You may be deleting the Submit Button name and type but are not unchecking it?
Bob
Hi Bob, I made sure to check that, and that's not the problem. I thought that perhaps I need to go back in and check all of the default fields and include them in the table. I watched a tutorial that said that it wasn't necessary to leave them checked, but I checked them anyway just to see. It allowed me to save my database. I went and filled out my form, then went to check the record. When I did, this is what I got. The default fields are filled out, but my custom fields are not:
[attachment=1]Screen Shot 2012-04-15 at 8.46.14 AM.png[/attachment]
Am I filling a field out wrong?
Here is an example of one field:
[attachment=0]Screen Shot 2012-04-15 at 8.48.21 AM.png[/attachment]
Thanks SO MUCH for helping me with this!
[attachment=1]Screen Shot 2012-04-15 at 8.46.14 AM.png[/attachment]
Am I filling a field out wrong?
Here is an example of one field:
[attachment=0]Screen Shot 2012-04-15 at 8.48.21 AM.png[/attachment]
Thanks SO MUCH for helping me with this!
I figured it out! I am a noob... I wasn't paying attention to the fact that I shouldn't name my table with spaces or underscores. I fixed that, and now it works. 🙂
Thank you.
Thank you.
This topic is locked and no more replies can be posted.