Jag gör en Insert ifrån en formulär som jag loopar ut dynamiskt. Men som vanligt så tycker jag att allt blir kakka.
Finns det några begränsningar med denna kod?
Tips?
'Forumulärsidan
<form action="insert.asp">
<input type="hidden" name="ual_uaid" value="63">
<input type="checkbox" name="CB_0" value="True">
<input type="text" name="fromdate" value="">
<input type="text" name="todate" value="">
<br>
<input type="hidden" name="ual_uaid" value="68">
<input type="checkbox" name="CB_1" checked value="True">
<input type="text" name="fromdate" value="">
<input type="text" name="todate" value="">
<br>
osv.
</form>
'Sidan insert.asp
for z = 0 to request.form("fromdate").count-1
Dim ual_uaid : ual_uaid = split(request.form("ual_uaid"),",")
Dim fromdate : fromdate = split(request.form("fromdate"),",")
Dim todate : todate = split(request.form("todate"),",")
strSql = "Insert Into tabell(ual_umid,ual_uid,ual_uaid,ual_fromdate,ual_todate)" &_
"Values('"& id &"','"& uid &"','"& ual_uaid(z) &"','"& fromdate(z) &"','"& todate(z) &"')"& request.form("CB_"& z &"")
Connect.Execute(strSql),,128
next