How can insert multiple value into sql server by the select option ?
multiple value (software) received from the page 1

Page 1
----------
<SELECT id=software name=software MULTIPLE SIZE="10"><OPTION selected value="">Select Software</OPTION>
<%
ssql="select distinct software from softwarelist2 order by software"

set rs=cn.Execute(ssql)
do while rs.eof=false
Response.Write("<option value='" & rs("software") & "'>")
Response.Write(rs("software") )
rs.movenext
loop
%>
</SELECT>

page 2
-----------
software=Request.Form("software")

software variable received multiple value ie. Microsoft xp, Microsoft 2000, visual studio, etc.
it should be insert ie.

Stn no software
------- ----------------
1 microsoft xp
2 microsoft 2000
3 visual studio


how can insert multiple value into sql server by following insert coding. ?
it insert in one raw.
It is separate value, and it should be save separate field.

isql1="insert into software2 (stn_no,software) values ("
isql2="'" & stn_no & "',"
isql3="'" & software & "')"

isql=isql1+isql2+isql3

cn.Execute isql

Please help

Mateen

If Request.Form("software").Count > 0 then

For i = 0 to Request.Form("software").Count - 1

' Validate input before doing the next line!!!
strSQL = "INSERT INTO myTable (StnNo, Software) VALUES (" & i + 1 & ", '" & Request.Form("Software")(i) & "')"
objConn.Execute strSQL,,adCmdText+adExecuteNoRecords

Next

End If


HTH

Cheers
Ken

Microsoft MVP - Windows Server (IIS)
www.adOpenStatic.com

Subkeys are the way around this. Just use software=Request.Form("software")(1) to get the 1st item the user selected, or software=Request.Form("software")(2) to get the 2nd item etc.

Request.Form("software").Count will tell you how many items the user selected, so you can use this to control a loop, for example
For n = 1 to Request.Form("software").Count
  '... build the insert statements using Request.Form("software")(n),
  ' separate each one with a ; at the end
Next
'execute all the inserts at once

thanks.