Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    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.

    TIA

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  2. #2
    Join Date
    Apr 2005
    Location
    Baltimore, MD
    Posts
    297
    Quote Originally Posted by sathyaram_s
    Env : My SQL 4.1.12-1 on Linux.
    ...
    What is the best way to implement this at the database side with this version of MySQL.
    MySQL 4.x does not support triggers or stored procedures, so you may want to try foreign keys. That would be my best guess.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •