With "array names" DB Save doesn't work

Hi

Chronofroms, the final Frontier. ;-)
Yes, i love Chronoforms and the helpfull staff here. But sometimes i'm lost in space..

New Case:

I wanted to build a form and connect it with a chrononnectivity Connection to allow an administrator to edit directly from a list.
So i had a form with a db save action. Everything worked fine.
So i had to rename the fields from "title" to "modelname[title]" , from "subtitle" to "modelname[subtitle]" an so on.
When i use the form (and the old DB), the db save function doesn't work anymore. My Form entries are lost.
So i created a new DB with Chronoforms (connected to my form) and i had now fieldnames like "modelname[title]" in the DB.

But: the DB Save doesn't work too.

Thank you
Chris

Hi Chris,

I find it difficult to get my had round this :-(

When you say " i had now fieldnames like "modelname[title]" in the DB." does that mean that the column name in the table is modelname[title]? Because you I don't think that you can use [] in MySQL column names?

Bob

Hi Bob

Yes, i created a table with chronoforms "create table" function.
Yes. It created me a table with "modelname[title]", "modelname[subtitle]" and so on.
An maybe this is the problem. Do i have to create the table in chronocennectivity?
Can i use fieldnames without "array names" to use it with chronoconnectivity?

Thank you
Chris

Hi Chris,

Please drop that table and create a new one - or edit that one in PHPMyAdmin and use the names without the model id e.g. title, subtitle, . . .

Bob