I&#039m trying to do an if..then statement that uses a variable and the return of a database, but I get a &#0390&#039for a response whent I&#039m supposed to get more than &#039 1&#039. Here&#039s the code.<BR>===<BR>set tvarProd = request.querystring("id")<BR>.<BR>.<BR>.<BR>i = 0<BR> sqlstmt = "SELECT prod_id FROM items WHERE cart_id = " & cart_id & ";"<BR> rs.open sqlstmt, conn, adOpenForwardOnly, adLockReadOnly<BR> do while not rs.eof<BR> if rs("prod_id") = tvarProd then<BR> i = i + 1<BR> end if<BR> rs.movenext <BR> loop<BR> rs.close<BR>response.write i<BR>===<BR>i&#039m supposed to get anything greater than &#039 1&#039, but i get a 0 in response. I know that it is in my if..then statement, because i&#039ve changed the boolean. any ideas?