Forums

I have a database table with 46 fields in it. A DBRead action read only the first 36 fields automaticaly. If i list the fields all in the field box of the dbread action all fields a read. But the DBSave does the same. It only save the first 36 fields the rest not.

Is there a limitation of field a dbread or dbsave action can handle?

Kind regards.

Jürg

Hi Jürg,

There is no limit in CF but there is a maximum record size in MySQL.

If you leave the column types as VARCHAR(255) when you create the table you can exceed this. Changing the column Types to sizes that fit the data should allow you to save all the data. There is a FAQ with more info on this.

Bob