Tickets :: [#721] Input fields don't recognize SQL limits

Summary	Input fields don't recognize SQL limits
Queue	Turba
Queue Version	HEAD
Type	Bug
State	Resolved
Priority	2. Medium
Owners	jan (at) horde (dot) org
Requester	seifert (at) everybody (dot) org
Created	2004-10-25 (5295 days ago)
Due
Updated	2004-10-26 (5294 days ago)
Assigned	2004-10-26 (5294 days ago)
Resolved	2004-10-26 (5294 days ago)
Milestone
Patch	No

2004-10-26 08:24:37	Jan Schneider	Comment #2 State ⇒ Resolved	Reply to this comment
You can customize the maximum size as well as the field size in attributes.php. I modified the default sizes in attributes.php.dist in CVS for the fields that we add in our SQL scripts.

2004-10-26 08:18:27	Jan Schneider	Assigned to Jan Schneider State ⇒ Assigned

2004-10-25 22:29:28	seifert (at) everybody (dot) org	Comment #1 Type ⇒ Bug State ⇒ Unconfirmed Priority ⇒ 2. Medium Summary ⇒ Input fields don't recognize SQL limits Queue ⇒ Turba	Reply to this comment
When using the SQL driver for Turba, the default table sets limits of 25 characters for the home phone, work phone, etc. However, the HTML entry form doesn't enforce this through the maxsize attribute. When the user attempts to save a record with an entry longer than the maximum allowed, he only gets the cryptic "DB Error". To add insult to injury, the default field length for the home phone and work phone fields are 40 characters, which certainly makes it look like it's safe to enter more than 40 characters.