Buy Now
Sign in

DB Save only fields in the Database

U Can Drive , March 10 at 12:29
Answered
U
U Can Drive
I know this may seem simple but I really can't get it.
In CFv5 a DBSave would naturally save all the information the Database had.
CFv6 seems to have an all or nothing attitude.​
​​
​I've found I can list each field separately under the "Data Override on Insert"
But it looks/reads like I should be able to put something in the "Data provider" to do this.​
​​
​Is there an easy way to only save all the fields IN the Database and no others?​
​If I use the "Auto save fields" option it adds the rest of the fields to the Database, I need to save some info to one Database and some to another Database.
Thank you in advance.
admin
Hi,
If you disable the "Auto manage table" setting in the "save data" then only the form fields matching the table fields will be saved, you may then have 2 "save data" action connected to 2 different tables if you want the data in 2 database tables.
Best regards
Max
If your main question got answered then please mark the answer using the button!​
​Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!
U
U Can Drive
Perfect, thank you. I'd tried that but hadn't re-enabled the Auto Save as well.