Forums

This topic is locked

Multiple Update Server Side

Posted 14 Jan 2002 16:55:50
1
has voted
14 Jan 2002 16:55:50 Aaron Jay posted:
I have a list of items, I want to mark as 'paid', by viewing a list drawn from my recordset, and checking boxes form multiples in the list. I can submit one from the list, and it runs my stored procedure on an update.asp page no problem, but when I tick off two or more boxes, it wont run the stored procedure correctly.

I thought if i did a:
<b>
For Each item in Request.Form("count"
Stored Procedure Updating Here
NEXT
</b>
it would work on each individual item and do the work based on the unique id supplied. But for some reason I dont think it can take the multiples.

The error I get is:
ADODB.Command error '800a0d5d'
The application is using a value of the wrong type for the current operation.

How should i work around this?



Reply to this topic