Forums

I've created a form with the following fields : name , lastname, telephone , email , message , code-job

After that, I've created a table in order to store the data of the fields into a table of my database.

When a user click the submit button, all the data of my fields is stored into my database except the field 'code-job' .

What can I do about this?

Hello tzervas,
I'm not a Chrono professional, but after checking your new post, I think that the following links may help:
My form data isn't saving to the database correctly
My CFv5 form data isn't saving to the database correctly
How do I save form data to a database table?
How to load record data from a database table into your form
How to debug database queries
How can I edit my database table and debug queries?
How can I connect to another database?
How can I select 'types' in a database table?
How can I edit a record from a database table?
How can I add a new column to a database table or change a column type?
P.S: I'm just an automated service😉

the input names I want to save should match the table column names exactly?

the input names I want to save should match the table column names exactly?

in my case all of them watch exactly

Hi tzervas,

Please rename the column and the input code-job to say code_job or codejob. Where there is a dash '-' in the column name MySQL requires the string to be quoted and CF doesn't always do this correctly.

Bob