Question
J Roberts - Batch update records in ASP
Hello Julian,
I have recently read your article on your website to Batch update records in
ASP which I found very helpful. I wonder if you could help me with a small
problem I have regarding this issue.
The section that says:
>When the form is submitted, we can loop through the recordset and update
>each record accordingly. eg:
><%
>While not rs.eof
>ProductID=rs("ProductID")
>rs("Product")=Request("Product" & ProductID)
>rs.Update
>rs.Movenext
>wend
>%>
obviously works but I am using a Dreamweaver Command that accesses a Stored
Procedure to do my Update. How would the above code be modified to
incorporate a Command in this way?
Thanks.
I have recently read your article on your website to Batch update records in
ASP which I found very helpful. I wonder if you could help me with a small
problem I have regarding this issue.
The section that says:
>When the form is submitted, we can loop through the recordset and update
>each record accordingly. eg:
><%
>While not rs.eof
>ProductID=rs("ProductID")
>rs("Product")=Request("Product" & ProductID)
>rs.Update
>rs.Movenext
>wend
>%>
obviously works but I am using a Dreamweaver Command that accesses a Stored
Procedure to do my Update. How would the above code be modified to
incorporate a Command in this way?
Thanks.
