| SuperValidator - Validate user input using programmable regular expressions |
The SuperValidator feature of ASP-db2000 is a unique feature you would not find in any other product. While most product uses local JavaScript code to "hard code" the validation mask, SuperValidator uses a regular expression engine to enable a programmable mask. If the browser type is IE then the color of a valid, incomplete and invalid can be defined by the user to inform the user about the validity of their input values.
Setup Validator to validate an input field. This property when defined (not blank) will setup all the JavaSscript code for the validation in standard or template conditions. In order to use the validator, the "AspdbValidator.jar" file must be either located in the Jars directory or a path defined by the Codebase parameter of dbValidatorParams.
Step by Step Example Procedures
| Property Syntax |
dbValidatorParams = "(;,)CodeBase,ValidateOnEntry,ValidColor,ValidMsg,InvalidColor,InvalidMsg, IncompleteColor,IncompleteMsg"
| Parameters |
|
Parameters |
Description |
| Codebase | Virtual location of the AspdbValidator.jar. This input is mandatory. |
| ValidateOnEntry | Default=True. Validates the
default values. Normally, validator only
validate a field upon a cursor or key to the input box. But when this
parameter is set to "True", then the default value in the input box is checked whether you visit the box
with the cursor/key or not. This action is very expensive and requires that the <Body Onload=IVInitStatuses()> is taken up by ASP-db. IN fact whne you click this box, this OnLoad will be appended to the <BODY ...> tag. However, using EditBodyTag (New keyword as BodyTag is for Grid & Form) in dbOptions will allow user body tags to be included. Without ValidateOnEntry, if the default values are invalid, then it 'll also be passed. As always, if cursor vist the box then content of the input box will already be validated. When validator is activated (dbValidatorParams<>"") then the EditValidateName of dbEditParams will have the value of "aspdbValidatorSubmit" and user will not be able to use this feature. |
| ValidColor | Color of text when input value is valid - Blue |
| ValidMsg | Message text when valid - OK |
| InvalidColor | Color of text when input value is invalid - Red |
| InvalidMsg | Message text when invalid - ERROR IN INPUT FIELD |
| IncompleteColor | Color of text when input value is not complete but valid - Magenta |
| IncompleteMsg | Message text when incomplete - INCOMPLETE FIELD |
| Example |
|
<% Set X= Server.CreateObject("ASP.DB") X.dbUnit = "999" X.dbMode = "Grid" X.dbValidatorParams = "http://localhost/aspdb/Jars" X.dbEditFlds = "(;,[]|~)Car,Manufacturer,Year[2001|2001|||1~ISNUMBER~3~2000~2005~~0~The year input should be #### ],Transmission,Price" X.dbEditParams = "(;,)TableName=CarSpecs, BookMarkFlds=Car" X.dbEditUpdateROFlds = "Car" X.dbDSN = "DSN=CARDB" X.dbNavigationItem = "Top,Prev,Next,Bottom,GridRow,Reload,Edit,Update,Delete,Add" X.dbSQL = "SELECT Car,Manufacturer,Year,Transmission,Price FROM CarSpecs" X.ASPdb %> |
| Notes |