Problem editing records having field names with embedded spaces

wilkenw

New Member
My mySQL database has many files with spaces embedded in their field names: for example, `First Name`.
When I attempt to edit any record in a Fabrik list with a field name taking this form, Fabrik destroys all data in all fields in the record having embedded spaces in their names. There is no problem, however, editing files having field names without embedded spaces: for example `FirstName`.
 
In my experience it is not common practice to use SQL column names with spaces in them. Indeed, I think that the SQL standard requires column names NOT to have spaces, so even if mySQL allows spaces, these names would be non-conforming.

The easiest solution would be to use phpmyadmin to take the spaces out from the field names.
 
We are in need of some funding.
More details.

Thank you.

Members online

No members online now.
Back
Top