ASP code error with SQL server databases

[Amit Kela]

Hey,
I am getting the following error when I try to delete the contents
of a recordset under a condition statement. Is there any way I can
delete them without running into this error?
I need to delete the contents in the recordset 'rs' to delete the
items from the shopping cart once the order is placed.
Thanks, Amit

Error Type:
ADODB.Recordset (0x800A0CB3)
Current Recordset does not support updating. This may be a limitation
of the provider, or of the selected locktype.
/FacLog/cartdisplay1.asp, line 370


Relevant code:
sql = "Select UserName,Code, Title From TempCartTable WHERE UserName=
'" & strName & "' ORDER BY Code"
set rs = db.execute(sql)

if session ("OrderPlaced") = "true" then
Response.Write " <div align = center> <font color=#FF0000><b>
<h2> Your Cart is Presently Empty !!! </h2> <b> </font> <div>"
end if

' Get all the Instructor Selections from TempCartTable
if session ("OrderPlaced") = "false" then
If not rs.eof Then
'Response.Write rs("title")
Response.Write "<h3> Database Requests </h3>"
Response.Write "<br><table border='1'>"
Response.Write "<tr> <td><div align=center><b> Remove
</b></div></td> <td><div align=center><b> Code </b></div></td>
<td><div align=center><b> Title </b></div></td> <td><div
align=center><b> Course Details </b></div></td> <td><div
align=center><b> Date Requested For </b></div></td><td><div
align=center><b> Comments </b></div></td>"
row=0

while not rs.eof
Response.write(flag)
row=row+1

Response.Write "<tr><td width='15'><a
href='cartdisplay1.asp?Remove="
Response.Write rs("Code")
Response.Write "'><img src='/images/dot03.jpg'></a></td><td>"
Response.Write rs("Code")
Response.Write "</td>"
Response.Write "<input type=hidden name='Code" & row
Response.Write "' Value='"
Response.Write rs("Code")
Response.Write "'>"
Response.Write "<td><a target=_parent href='FacMenuFS.html?Code="&
rs("Code") & "'><font color='#006699'>"
Response.Write rs("Title")
Response.Write "</font></td> <div align=center><td>"
Response.Write "<input type=hidden name=""Title" & row
Response.Write """ Value=""" & Server.HtmlEncode(rs("Title"))
Response.Write """>"

[Aaron Bertrand - MVP]

Use a DELETE statement to affect data.

conn.execute "DELETE table WHERE key=" & key,,129

Not only does it avoid the problem you're having, it is also more efficient.

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]




"Amit Kela" <amit.kela@colorado.edu> wrote in message
news:8e5e432b.0312021441.28565883@posting.google.c om...

> Hey,
> I am getting the following error when I try to delete the contents
> of a recordset under a condition statement. Is there any way I can
> delete them without running into this error?
> I need to delete the contents in the recordset 'rs' to delete the
> items from the shopping cart once the order is placed.
> Thanks, Amit
>
> Error Type:
> ADODB.Recordset (0x800A0CB3)
> Current Recordset does not support updating. This may be a limitation
> of the provider, or of the selected locktype.
> /FacLog/cartdisplay1.asp, line 370
>
>
> Relevant code:
> sql = "Select UserName,Code, Title From TempCartTable WHERE UserName=
> '" & strName & "' ORDER BY Code"
> set rs = db.execute(sql)
>
> if session ("OrderPlaced") = "true" then
> Response.Write " <div align = center> <font color=#FF0000><b>
> <h2> Your Cart is Presently Empty !!! </h2> <b> </font> <div>"
> end if
>
> ' Get all the Instructor Selections from TempCartTable
> if session ("OrderPlaced") = "false" then
> If not rs.eof Then
> 'Response.Write rs("title")
> Response.Write "<h3> Database Requests </h3>"
> Response.Write "<br><table border='1'>"
> Response.Write "<tr> <td><div align=center><b> Remove
> </b></div></td> <td><div align=center><b> Code </b></div></td>
> <td><div align=center><b> Title </b></div></td> <td><div
> align=center><b> Course Details </b></div></td> <td><div
> align=center><b> Date Requested For </b></div></td><td><div
> align=center><b> Comments </b></div></td>"
> row=0
>
> while not rs.eof
> Response.write(flag)
> row=row+1
>
> Response.Write "<tr><td width='15'><a
> href='cartdisplay1.asp?Remove="
> Response.Write rs("Code")
> Response.Write "'><img src='/images/dot03.jpg'></a></td><td>"
> Response.Write rs("Code")
> Response.Write "</td>"
> Response.Write "<input type=hidden name='Code" & row
> Response.Write "' Value='"
> Response.Write rs("Code")
> Response.Write "'>"
> Response.Write "<td><a target=_parent href='FacMenuFS.html?Code="&
> rs("Code") & "'><font color='#006699'>"
> Response.Write rs("Title")
> Response.Write "</font></td> <div align=center><td>"
> Response.Write "<input type=hidden name=""Title" & row
> Response.Write """ Value=""" & Server.HtmlEncode(rs("Title"))
> Response.Write """>"