Is there anybody out there? - So many questions PLEASE HELP!

SwingeyP 18 Jan, 2021
I have a form of mainly text fields and a calendar entry.

I want to spit this data into an 'EXTERNAL' database.

I have a database 'Data' with some tables 'SiteDetails'

I have managed to get a database connection working and can see the tables in 'Database Connection 1'

I have put the 'Save Data' action in the actions area for the field.
Now comes my questions:

How does the 'Save Data' know what fields map to what database field?

If I run the form and sbmit it all seems to go OK but the table fields in the database aren't being populated. They're just blank.


Can someone PLEASE help me get this working?
GreyHead 18 Jan, 2021
Answer
Hi SwingeyP,

Basically the names of the CF data entries need to be the same as the corresponding columns in the database table.

Bob
SwingeyP 18 Jan, 2021
Thanks Bob. I shold have seen that one - doh!
You need to login to be able to post a reply.