var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Validate Zip code
Env : My SQL 4.1.12-1 on Linux.
Let's say, I have two tables
1) user_details (username,ueraddress,userzipcode) all CHAR fields
2) zipcodelist (zipcode, cityname)
When a user enters his/her zipcode, I want to validate that this is a valid zipcode before inserting into the user_details table.
The web appl is in Jave (JSP).
What is the best way to implement this at the database side with this version of MySQL.
Visit the new-look IDUG Website
, register to gain access to the excellent content.
MySQL 4.x does not support triggers or stored procedures, so you may want to try foreign keys. That would be my best guess.
Originally Posted by sathyaram_s