Forums

comma in field name accepted, populating table: error

freezer 25 Nov, 2010
okay, it's not so nice to use a comma in a field name (e.g. "prod,type"), but if you do, and you create a DB table for the form, then in the table two columns (prod and type) are being generated. Populating the table gives an error.

I know that mysql does not accept a comma in a column name.

Suggestion: present a warning or error message after pressing the "create table" button, when a field containing a comma exists.

Cheers.
GreyHead 25 Nov, 2010
Hi Freezer,

True, not actually sure it's a bug though. Maybe it's a desirable feature. It's certainly illegal HTML. Input names can contain a-z, A-Z, 0-9 and underscore '_' - no spaces, dashes or other special characters - and they must start with a letter.

Bob
This topic is locked and no more replies can be posted.