Sql Validation For Text Input Box Data Follow
Hi. I am looking for a way to check a value entered into a text input box on the data entry form against data in a single column of a SQL database. I’m fairly certain that this is possible with vbscript but do not know where to start. I can successfully query the SQL DB to fill a dropdown list, but I need help checking the value in a text input box and putting up a message for the user that says something to the effect of, “Invalid entry,” if they enter a value that does not exist in the DB. Any help provided would be appreciated.
Please sign in to leave a comment.