|
 |
asp_databases thread: Adding records to a table
Message #1 by "Steve Burr" <steveb1164@a...> on Fri, 22 Jun 2001 19:44:39
|
|
In the code below, I am trying to write only the first 3 teams to the
table. For some reason all 5 teams are being written to the table. Can
someone help me out? What am I missing?
count = 1
teams = 3
If count <= teams Then
team1 = Request.Form("team1")
rsplayers.AddNew
rsplayers("userid") = userid
rsplayers("team") = team1
rsplayers.Update
count = count + 1
End If
If count <= teams Then
team2 = Request.Form("team2")
rsplayers.AddNew
rsplayers("userid") = userid
rsplayers("team") = team2
rsplayers.Update
count = count + 1
End If
If count <= teams Then
team3 = Request.Form("team3")
rsplayers.AddNew
rsplayers("userid") = userid
rsplayers("team") = team3
rsplayers.Update
count = count + 1
End If
If count <= teams Then
team4 = Request.Form("team4")
rsplayers.AddNew
rsplayers("userid") = userid
rsplayers("team") = team4
rsplayers.Update
count = count + 1
End If
If count <= teams Then
team5 = Request.Form("team5")
rsplayers.AddNew
rsplayers("userid") = userid
rsplayers("team") = team5
rsplayers.Update
count = count + 1
End If
Message #2 by workflow <workflow@s...> on Sat, 23 Jun 2001 09:44:34 +0530
|
|
Hi,
You can try this Code,
<%Dim teams
Dim i
For i =3D 1 to 5
team & i =3D Request.Form("team"&i)
if team&i <> "" then=09
rsplayers.AddNew
rsplayers("userid") =3D userid
rsplayers("team") =3D team & i
rsplayers.Update
End If
Next %>
I hope it may works and send a reply to me
> -----Original Message-----
> From: Steve Burr [SMTP:steveb1164@a...]
> Sent: Saturday, June 23, 2001 1:15 AM
> To: ASP Databases
> Subject: [asp_databases] Adding records to a table
>
> In the code below, I am trying to write only the first 3 teams to the
> table. For some reason all 5 teams are being written to the table.
Can
> someone help me out? What am I missing?
>
> count =3D 1
> teams =3D 3
>
> If count <=3D teams Then
> team1 =3D Request.Form("team1")
> rsplayers.AddNew
> rsplayers("userid") =3D userid
> rsplayers("team") =3D team1
> rsplayers.Update
> count =3D count + 1
> End If
> If count <=3D teams Then
> team2 =3D Request.Form("team2")
> rsplayers.AddNew
> rsplayers("userid") =3D userid
> rsplayers("team") =3D team2
> rsplayers.Update
> count =3D count + 1
> End If
> If count <=3D teams Then
> team3 =3D Request.Form("team3")
> rsplayers.AddNew
> rsplayers("userid") =3D userid
> rsplayers("team") =3D team3
> rsplayers.Update
> count =3D count + 1
> End If
> If count <=3D teams Then
> team4 =3D Request.Form("team4")
> rsplayers.AddNew
> rsplayers("userid") =3D userid
> rsplayers("team") =3D team4
> rsplayers.Update
> count =3D count + 1
> End If
> If count <=3D teams Then
> team5 =3D Request.Form("team5")
> rsplayers.AddNew
> rsplayers("userid") =3D userid
> rsplayers("team") =3D team5
> rsplayers.Update
> count =3D count + 1
> End If
>
|
|
|
View Cart
