<% 'declare SQL statement that will query the database sSQL="SELECT slno,quantity FROM cart WHERE id='" & request.QueryString("hidID") & "' and sessionid=" & session.SessionID 'define the connection string, specify database 'driver and the location of database sConnString="PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & Server.MapPath("cart.mdb") 'create an ADO connection and recordset Set connection = Server.CreateObject("ADODB.Connection") Set recordset = Server.CreateObject("ADODB.Recordset") 'Open the connection to the database connection.Open sConnString 'Open the recordset object, execute the SQL statement recordset.Open sSQL,connection %> <% 'first of all determine whether there are any records slno = 0 If not Recordset.EOF Then itemexists = true slno = recordset("slno") %> <%end if %>

Item Already Added to Cart and it's Quantity is : <%=recordset("quantity")%>
Item	<%=request.QueryString("hidname")%>
Price	<%=request.QueryString("hidPrice")%>
Add Quantity
	"> "> "> <%if itemexists = true then %><% End If%>