% a_id=request.querystring("id") %> <% set rs=server.createobject("adodb.recordset") sql="select [title] from [article] where [id]="&a_id&" and view_yes=1" rs.open(sql),cn,1,1 if not rs.eof then ProductName=rs("title") end if rs.close set rs=nothing %>