Detail-Master updating problem

CW · October 21st, 2003, 04:14 AM

Hi.

I have Detail-Master relationship, but also i want to update the data in the detail.asp.

Inorder to display a detail.asp, i used a UseriD to store the request.form(ID)from the master.asp. Then in that UserID, i used to retrieve the detail info for that ID.

But i want to update the retrieved data in the datail.asp ?

I have added "edit" link in the detail.asp and again used the UserID , so that i will again retrieve detail info in input boxes where i can make changes to it and update.
But my problem is " the edit link can not capture the USERID".

IF i put the mouse on the link, i can only see "update_form.asp?ID = "

How can i capture the userID in teh detail.asp?
How can be updated detail.asp in Master-detail relationship ??

Thanks in advance

CW · October 21st, 2003, 08:22 AM

This is the code.

<html>
<head>
<title>detail</title>
</head>
<body>
<BR>
<%
UserID=Request.QueryString("ID")
dim oRSmt
set oRSmt=server.createobject("ADODB.recordset")
sqlText="Select * from Student WHERE ID="& UserID & ""
oRSmt.Open sqlText, "DSN=XYSN"
%>

<center> <br><br><br><br><br>
   <TABLE border=1 cellspacing=1>

   <TR>
        <TD COLSPAN=6 ALIGN=CENTER> The Details </TD>
   </TR>
   <TR>
           <TH BGCOLOR=navy> Student ID</TH>
        <TH BGCOLOR=navy> First Name </TH>
        <TH BGCOLOR=navy> Last Name </TH>
        <TH BGCOLOR=navy> DOB </TH>

    </TR>

<%

  Do while NOT oRSmt.EOF

  %>

   <TR>
      <TD><%=oRSmt("ID")%></TD>
      <TD><%=oRSmt("FirstName")%></TD>
      <TD><%=oRSmt("LastName")%></TD>
      <TD><%=oRSmt("DOB")%></TD>

    </TR>
    </center>
    <%

     oRSmt.MoveNext
Loop
oRSmt.Close
Set oRSmt = Nothing

%>

</TABLE>
<center>
<p><a href="update_form.asp?ID="oRSmt("& UserID &")>edit</a></p>
   </center>

</body>
</html>

thanks in advance

CW · October 22nd, 2003, 10:18 AM

Hi.

again

I have got the solution of this problem.

C U

:-)