<% v_BrandID = request("cbobrand") v_State = request("txtstate") Set DBConn = Server.CreateObject("ADODB.Connection") Set Rs = Server.CreateObject("ADODB.Recordset") DBConn.Open Session("DSN") %>
Brand:
<% if v_State = 1 then 'Select from this table to get the data SQL = "p_get_model_keywords " & v_BrandID RS.Open SQL,DBConn %> <% 'Loop the Popular Database Do until Rs.EOF = true Response.write replace(rs.Fields(0),"BLANK","") & "
" Rs.movenext Loop set DBConn = nothing set Rs = nothing End if %>