<% sel = request("sel") %>
<% sel2= request("sel2")%>
<% sch = request("sch")%>
<% sort= request("sort")%>
<%
cnnMDI="DSN=frame;uid=frame;pwd=frame"
Set rs = Server.CreateObject("ADODB.Recordset")
if sch = "M" or sort = "M" then
if sel2 = "+" then
sqlUser="SELECT * FROM frame where model = '" & sel & "' order by model,framename"
elseif sel = "z" then
sqlUser="SELECT * FROM frame where model < '" & sel2 &"' or model >= '" & sel & "' order by model,framename"
else
sqlUser="SELECT * FROM frame where model < '" & sel2 &"' and model >= '" & sel & "' order by model,framename"
end if
else
if sel2 = "+" then
sqlUser="SELECT * FROM frame where framename = '" & sel & "' order by framename,model"
elseif sel = "z" then
sqlUser="SELECT * FROM frame where framename < '" & sel2 &"' or framename >= '" & sel & "' order by framename,model"
else
sqlUser="SELECT * FROM frame where framename < '" & sel2 &"' and framename >= '" & sel & "' order by framename,model"
end if
end if
'response.write "sqluser= ["&sqlUser&"] "
rs.open sqlUser, cnnMDI
'Set Conn = Server.CreateObject("ADODB.Connection")
'Conn.Open "savantlight"
'Set RS = Conn.Execute("SELECT * FROM products")
%>
Clip House - Frame Search
