Monday, 27 August 2007

Problems with the shopping card delete section:


ADODB.Recordset error '800a0cc1'

Unknown runtime error

/phr004/coursework1/addCart.asp, line 42

Solution:

Resolved by typing in card_id in the line below:

RS.Open sqlString

WHILE NOT RS.EOF

newQ = TRIM( Request( "pq" & RS( "cart_id" ) ) )

deleteProduct = TRIM( Request( "pd" & RS( "cart_id" ) ) )

IF newQ = "" OR newQ = "0" OR deleteProduct <> "" THEN

RS.Delete

ELSE

IF isNumeric( newQ ) THEN

RS( "cart_quantity" ) = newQ

END IF

No comments: