hello!



is it possible to update multiple records from one page?



for example i have a 2 column db table in access with a load of recording

artists in column 1 and no entry's in column 2. eg:



ARTIST                  SONG

Janes Addiction

The Who

Underworld



what i'd like to do is build a form page that brings up the artists with a

txt box next each - when the user enters a value in the txt box, i want it

to fgo into the database to produce:



ARTIST                  SONG

Janes Addiction     Nothings Shocking

The Who               My Generation

Underworld           King of Snake



is this possible? or will i have to go through one at a time?



cheers,



jake

Create a hidden input field that contains the list of recordIDs.

Then create you input fields with the *names* of the form elements based on
the recordID, eg:

<input type="text" name="txtSongName_<%=objRS("ID")%>">

Then, when you submit the form you can do:

<%
If Request.Form("RecordID").Count > 0 then

    For i = 1 to Request.Form("RecordID")(i)

        Response.Write(Request.Form("txtSongName_" &
Request.Form("RecordID")(i)) & "<br>")

    Next

End If
%>

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "jake williamson 28" <jake.williamson@2...>
Subject: [access_asp] multiple updates on one page


:
: hello!
:
: is it possible to update multiple records from one page?
:
: for example i have a 2 column db table in access with a load of recording
: artists in column 1 and no entry's in column 2. eg:
:
: ARTIST                  SONG
: Janes Addiction
: The Who
: Underworld
:
: what i'd like to do is build a form page that brings up the artists with a
: txt box next each - when the user enters a value in the txt box, i want it
: to fgo into the database to produce:
:
: ARTIST                  SONG
: Janes Addiction     Nothings Shocking
: The Who               My Generation
: Underworld           King of Snake
:
: is this possible? or will i have to go through one at a time?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: