updating multiple records on one page

[BP Prgm]

I'm a moderate newcomer to ASP... I have a SQL Server database. I am
displaying multiple records on a page. I have a field in the database called
LatestUpdate. I read multiple records out of the database and put the
LatestUpdate data into a text box. I want the user to be able to edit
multiple text boxes and save them all with one click. At the bottom of the
page I will put a "Save All" button so I can update all records. How do I
make the "Save All" button update each record?

Thanks in advance! Code is always appreciated :-)

[Ray at home]

One way to do it is name your textboxes in a certain way, like with all the
same name but with an ID number as a suffix or something along those lines.
Something like this:


<form method="post" action="whatever.asp">
<input name="txtFirstname1" value="Jorg" type="text">
<input name="txtFirstname32" value="Marissa" type="text">>
<input name="txtFirstname45" value="Kylie" type="text">>
<input name="txtFirstname94" value="Yanni" type="text">>

<input name="cmdSubmit" value="Update All" type="submit">
</form>

On the page that processes:

<%
'''assuming multiple submit buttons all having the same name
If Instr(Request.Form("cmdSubmit"), "Update All") > 0 Then
'''update all
For Each f in Request.Form
If Instr(f, "txtFirstname") = 1 Then
'''this is a firstname textbox
'''get the record ID
sRecordID = Right(f, Len(f) - Len("txtFirstname"))
sFirstname = "'" & Replace(Request.Form(f),"'", "''))
sSQL = "UPDATE [TheTable] SET [Firstname]=" & sFirstname & "
WHERE [ID]=" & sRecordID
oYourADOConnection.Execute sSQL
End If
Next
oYourADOConnection.Close
Set oYourADOConnection = Nothing
End If


Actually, if you're having an option to update just one or update all, your
submit buttons will probably all have different names. But that won't
affect the code significantly.

Ray at home



"BP Prgm" <nospam@please.com> wrote in message
news:OeN03oJfDHA.3024@tk2msftngp13.phx.gbl...

> I'm a moderate newcomer to ASP... I have a SQL Server database. I am
> displaying multiple records on a page. I have a field in the database

called

> LatestUpdate. I read multiple records out of the database and put the
> LatestUpdate data into a text box. I want the user to be able to edit
> multiple text boxes and save them all with one click. At the bottom of the
> page I will put a "Save All" button so I can update all records. How do I
> make the "Save All" button update each record?
>
> Thanks in advance! Code is always appreciated :-)
>
>