<!-- #include file="security.asp" -->
<!-- #include file="incADO.asp" -->

<% 
lid = request("id")
strUserName = session("UserName")

' Create a recordset object to store specific table information
		Set objWatch = Server.CreateObject("ADODB.Recordset")

		'Establish what records you want selected for the SQL query string
		SQL = "Select * From TblWatchList where UserName = '" + strUserName + "' and CDListingId=" & lid

		'Set the recordset object equal to the SQL query string
		objWatch.Open SQL, objADO, 1, 3

			if objWatch.EOF then
			objWatch.addnew
			objWatch("CDListingId") = lid
			objWatch("UserName") = session("UserName")
			
			objWatch.update
			end if 
			
			Response.Redirect "detail.asp?Message=Vehicle Was Added To Your Watch List&id=" &lid
			
			
%>