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	10/25/2004 (7558 days ago)
Due
Updated	10/26/2004 (7557 days ago)
Assigned	10/26/2004 (7557 days ago)
Resolved	10/26/2004 (7557 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	No

10/26/2004 08:24:37 AM	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.

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

10/25/2004 10:29:28 PM	seifert (at) everybody (dot) org	Comment #1 State ⇒ Unconfirmed Priority ⇒ 2. Medium Type ⇒ Bug 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.