The following code gives me an Object required" error message. Any1 got any ideas? (I need to append the value contents of a database field to the name value of an html inout box).
<html>
<body>
<%ENABLESESSIONSTATE=False %>
<%
Dim DB
Set DB = Server.CreateObject ("ADODB.Connection")
DB.Open ("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=C:\Inetpub\wwwroot\test\test2.2.mdb")
Dim RS
Set RS = Server.CreateObject ("ADODB.Recordset")
RS.Open "SELECT * FROM SprogTbl", DB
dim sid
Response.Write RS.Fields("SprogNo") = sid
rs.movefirst 'RS.Fields("SprogNo")
while rs.EOF=false
for each sid in rs.Fields
x = sid + 0
%>
<form action="report-ammend2.42.asp" method="post"name="form">
<table border=1>
<tr><td>Sprog No.</td>
<td>1st report</td>
<td> 2nd report</td></tr>
<tr><td><input type="hidden" name="SprogNo<% = Response.Write (write.sid) %>" value="<%Response.Write RS.Fields("SprogNo")%>"><% response.write RS.Fields("SprogNo")%></td>
<td><input type="text" name="Report<%= sid %>" value="<%Response.Write RS.Fields("Report")%>"></td>
<td><input type="text" name="rep2<%= sid %>" value="<%Response.Write RS.Fields("rep2")%>"></td></tr>
<%
RS.movenext RS.Fields("SprogNo")
next
wend
%>
</table>
<br>
<input type="submit" value="submit">
<input type="button" value="Cancel" >
</form>
</body>
</html>
multiple and non sequential update blues....
