Menu

#221 Field length mismatches in Admin edit pages

open
nobody
None
2
2007-09-16
2003-07-23
No

I'm working with the oci8 schema, so it may not be
generic, but there a lots of places in the Admin HTML
where the form fields allow more character input than
is defined for the matching column in the database.

Example: Project name allows 40 characters in the form
box, but the schema defines a max width of 30.

At least on Oracle, submitting more data than will fit
in the column causes a database error. Since there
appears to be no other error handling on these inputs,
it's imperative that the HTML forms not permit more input.

Better solution would be define all such potentially
configurable field lengths as a template variable that
is used in both the HTML and schema definitions. Or do
better error handling; this is difficult since each
database type returns this error differently.

Discussion

  • Ulf Erikson

    Ulf Erikson - 2005-09-21
    • priority: 5 --> 7
     
  • Bryce Nesbitt

    Bryce Nesbitt - 2007-09-16
    • priority: 7 --> 2
     

Log in to post a comment.