How to insert multiplecheck box values in to database

Originally posted by : kader (ahmkader@hotmail.com)HiI have an problem to insert multiple check box values in to data base, i couldn't insert more than one valu, please suggest me to complete.Thank youkadermy file is:---------- Your Interest: Drama/Concerts Self-Improvement course Healthy Lifestyle Computers/Electronics Deco/Furnishings Music result page:

Originally posted by : dim condim rstconst adOpenKeyset = 1const adLockOptimistic = 3dim inderestset con=server.createobject("ADODB.connection")set rst=server.createobject("ADODB.Recordset")con.open "FILEDSN=C:Inetpubwwwrootdemocheck_src.dsn"rst.Locktype = adLockOptimisticrst.open "select * from check",con,adOpenKeyset,adLockOptimistic'Lets loop thru the request.form("interest").For each interest in request.form("interest")rst.AddNew rst("interest")=interestNextrst.update rst.movelastrst.closecon.close ------------kader at 10/22/2001 4:22:34 AMHiI have an problem to insert multiple check box values in to data base, i couldn't insert more than one valu, please suggest me to complete.Thank youkadermy file is:---------- Your Interest: Drama/Concerts Self-Improvement course Healthy Lifestyle Computers/Electronics Deco/Furnishings Music * result page: