Hi guys,

How can I insert multiple form field values into the same column in a sql2000 database.

I have a form which requests 5 zip codes from the user. These 5 zipcodes need to be inserted into 1 column as 5 rows. The insert UD4 behavior will only allow a single value to be entered into a column. is it possible to insert one at a time by looping through the 5 fields. How can I do this and does anyone know of a good tutorial.

my form has 6 fields and the user can enter from 1 to 5 zip codes.
zip1
zip2
zip3
zip4
zip5
userID (a hidden field which store the userId number)

My zip code table has 3 columns

entry id (primary key )
user id (foreign key to user table)
zipcodes (column to hold all the zipcodes)

help is desperately needed on this one!!! it's the only step remaining to complete my site.

thanks,

rob

Dear Rob,
You need to enter the zip codes as an array, then parse that array when you need to display them again.

Regards,
Brent