<%@ language = "VBScript"%>
Type in the name of the printer or the model name in the above text box to 
see the details regarding its cartridge, ribbons and refill kits. 
You can even type in some starting letters to get the matching printer models below.

Type in the Letter or Word you want to search for...
<%submit=Request.form("submit")%> <% set conn = server.createobject("ADODB.Connection") conn.Open "dsn=abeedatabase;uid=abee;pwd=abee2001info" set RS = server.createobject("ADODB.Recordset") %> <%if Request.form("text")<>"" then text = trim(Request.form("text")) text=Request.form("text") text = UCASE(text) %> <%if text <> "" then %> <%if LEN(text) = 1 then%> <%RS.open "select * from newtable where machine like '["&text&"]%'" ,conn %> <%else%> <%RS.open "select * from newtable where machine like '%"&text&"%'" ,conn %> <%end if%>

<%if RS.EOF = True then%>
No Match Found!!!!!!!!!!!!
<%else%> <%RS.MoveFirst%> <%while not RS.EOF%> <%RS.movenext%> <%wend%> <%end if%> <%end if%> <%end if%>
Machine
&item0=<%=RS("specification")%>&item1=<%=RS("fabricink")%>&item2=<%=RS("images")%>&our_page=<%=RS("our_page")%>&userinput=<%=text%>"><%=RS("Machine")%>
Top