Esempio:
(ometto un po di codice che do per scontato mettendo ... )
form.asp
codice:
<%
set conn = ...
conn.open ...
sql = "SELECT * FROM tabella1"
set rs = conn.execute(sql)
if not rs.eof then
%>
<form method="post" action="pagina.asp">
<%
do until rs.eof
%>
<input type="text" name="id_<%=rs("campoID")%>" value="<%=rs("campoTitolo")%>" />
<%
rs.moveNext
loop
%>
<input type="submit" value="Esegui" />
</form>
<%
end if
rs.close
set rs = nothing
conn.close
set conn = nothing
%>
pagina.asp
codice:
<%
set conn = ...
conn.open ...
for each item in request.form
if left(item,3) = "id_" then
tmpID = mid(item,4)
tmpValue = request.form(item)
sql = "UPDATE tabella1 SET campoTesto = '" & tmpValue & "' WHERE campoID = " & tmpID
conn.execute(sql)
end if
next
conn.close
set conn = nothing
%>