chima
asked on
Javascript input box and database effects
Hello
What are the failures caused by a javascript input box that does not have an upper limit boundary, relative to the database variable.
For example; an input box needs to accept 10 integers, but one can enter 200 integers. What will this do to the database, if the database variable only accepts 10 integers.
What happens for the opposite; the javascript allows only 10 integer, but the database variable needs 200 integers.
What are the failures caused by a javascript input box that does not have an upper limit boundary, relative to the database variable.
For example; an input box needs to accept 10 integers, but one can enter 200 integers. What will this do to the database, if the database variable only accepts 10 integers.
What happens for the opposite; the javascript allows only 10 integer, but the database variable needs 200 integers.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
How an app or database handles errors is directly up to the developers or dba's that set it all up.
For example: For my database, some calls generate an exception I expect the developers to handle. Some calls, the database handles exceptions internally and the developers never know anything ever went wrong.
>>I'm not a programmer.
If you can provide more information about the reason for the question maybe we can provide a response more tailored for you.
For example: For my database, some calls generate an exception I expect the developers to handle. Some calls, the database handles exceptions internally and the developers never know anything ever went wrong.
>>I'm not a programmer.
If you can provide more information about the reason for the question maybe we can provide a response more tailored for you.
ASKER
slightwv, I'm a test engineer, and while not an expert in javascript, html, or java, I do know that there should be an upper boundary on the number of integers/digits that an input box should accept. My question is; what happen on the database when the variable it is receiving is larger. I would think that the database would tuncat the number. Ideally the web page should generate an error indicating that the variable is being altered.
When the input box holds a smaller number than what the database variable is expecting, this may not cause any noticeable problems.
When the input box holds a smaller number than what the database variable is expecting, this may not cause any noticeable problems.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you for your verification.
ASKER