Skip to main content
Inspiring
October 26, 2006
Question

J Roberts - Batch update records in ASP

  • October 26, 2006
  • 2 replies
  • 338 views
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.


This topic has been closed for replies.

2 replies

Inspiring
October 27, 2006
Thanks Julian.


"Julian Roberts" <nospam@charon.co.uk> wrote in message
news:ehqu1t$cbp$1@forums.macromedia.com...
> You could put a wrapper around your proc. Like
>
> <%
> While not rs.eof
> ProductID=rs("ProductID")
> %>
> put proc code here
> <%
> rs.Movenext
> wend
> %>
>
> --
> Jules
> http://www.charon.co.uk/charoncart
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>
>


Inspiring
October 26, 2006
You could put a wrapper around your proc. Like

<%
While not rs.eof
ProductID=rs("ProductID")
%>
put proc code here
<%
rs.Movenext
wend
%>

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004