OK, now that I got the function working and I looked in a couple forums and realized I can't do server-side database manipulations in this function, I'm stuck again.
In this function I need to delete records from the database on the server.
This is what I wrote so far:
<% Dim connCW %>
<% Set connCW = Server.CreateObject("ADODB.Connection"

%>
<% connCW.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=D:\home\snaegele\Cougar\Cougar.mdb" %>
<SCRIPT LANGUAGE="VBSCRIPT">
Sub cmdDelete_OnClick
Dim i, strDate, message, rsDelete, strQuery, strID, intscid
For i=0 to Document.frmdisplaysc.Elements.Length - 1
If Document.frmdisplaysc.Elements(i).Name = "del" Then
If Document.frmdisplaysc.Elements(i).Checked Then
<% strID = Session("scID"

%>
<% intscid = CInt(strID) %>
strQuery = "DELETE FROM SHOPPINGCART WHERE SCID = " & intscid & " AND DATE = " & Document.frmdisplaysc.Elements(i).VALUE
* connCW.Execute(strQuery)
Navigate ("displaysc.asp"

Exit For
End if
End if
Next
End Sub
</SCRIPT>
I get the error message that says:
Error:Object required: 'connCW'
on the line with the *
The sub-routine is executed when they click the cmdDelete button and checks all of the check boxes(Name="del"

in the table to see if they are checked or not - if they are, that item(recognized by the SCID and the DATE columns in the table) is deleted from the table and the page is refreshed showing the Shopping Cart without the deleted item.
Is there a way to write this function server-side instead of client-side, and if not, how can I do this on the client-side?