I'm not overly familiar with ASP but I'm trying to build a shopping cart using ultra dev and Access. I have it set up so that after a user selects an item to buy (s)he goes to checkout page where the item is there. I want the user to be able to delete an item from their cart so I've inserted a radio button (named deleteID). I then inserted the delete server behavior and made the following changes to the default code,
I removed the following line:
<input type="hidden" name="MM_recordId" value=<%= rsCart.Fields.Item("cartID"
.Value %>">
I changed the following line:
if (CStr(Request("MM_delete"
) <> "" And CStr(Request("MM_recordId"
) <> ""
Then
to
if (CStr(Request("MM_delete"
) <> ""
Then
and I changed the following line:
MM_editQuery = "delete from " & MM_editTable & " where " & MM_tableCol & " = " & MM_redordID
to
MM_editQuery = "delete from tblCart where cartID='" & Request("DeleteID"
&" ' "
When I try to delete an item I get the following error message:
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/blackwood_gallery/checkout.asp, line 52.
Line 52 is MM_editCmd.Execute
I know this is a lot but if anyone can help me I'd really appreciate it.
Thank you very much.
Jeevenze
I removed the following line:
<input type="hidden" name="MM_recordId" value=<%= rsCart.Fields.Item("cartID"
I changed the following line:
if (CStr(Request("MM_delete"
to
if (CStr(Request("MM_delete"
and I changed the following line:
MM_editQuery = "delete from " & MM_editTable & " where " & MM_tableCol & " = " & MM_redordID
to
MM_editQuery = "delete from tblCart where cartID='" & Request("DeleteID"
When I try to delete an item I get the following error message:
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/blackwood_gallery/checkout.asp, line 52.
Line 52 is MM_editCmd.Execute
I know this is a lot but if anyone can help me I'd really appreciate it.
Thank you very much.
Jeevenze