<%@ LANGUAGE="JAVASCRIPT" %> <% var category,keyword,max,min; var recordSet = Server.CreateObject("ADODB.RecordSet"); var database = Server.CreateObject("ADODB.Connection"); var sql; var i,max; var id = null; var idString=null; database.Open("asp_database","asp_dev",""); keyword = Request.Form("keyword"); if((""+keyword) == "undefined") keyword = null; max = ""+Request.Form("max"); if((""+max) == "undefined") max = null; min = ""+Request.Form("min"); if((""+min) == "undefined") min = null; if((keyword != null)&&((""+keyword) != "")) { sql = "select * from products where " sql += "pname like '%"; sql += keyword; sql += "%' or description like '%"; sql += keyword; sql += "%'"; recordSet.Open(sql,database); idString = "prod_id"; } else if((max != null)&&(min != null) &&((""+max) != "")&&((""+min) != "")) { sql = "select * from products where " sql += "(originalprice >= "; sql += min; sql += ") and (originalprice <= "; sql += max; sql += ")"; recordSet.Open(sql,database); idString = "id"; } else if(Request.Form("category").Count > 0) { sql = "select * from cat_table where " max = Request.Form("category").Count; for(i=1;i<=max;i++) { if(i>1) sql += " or "; sql += "(catname = '"; sql += Request.Form("category")(i); sql += "')"; } recordSet.Open(sql,database); idString = "prodid"; } %> Search Products
Login
Register
Sell
Home
Help

JEDY INFOTECH

  Logout About Us Contact Us
Search:
     
Advanced Search Browse Category List All Products
<% if(idString != null) { %> <% } %>
Search For A Product
Current Matches:
    <% while(!recordSet.EOF) { id = recordSet(idString); Response.Write(id); Response.Write(" inspect"); Response.Write(" Buy
    "); recordSet.MoveNext(); } recordSet.Close(); %>
Search criterion:
Keyword:
Min Price: Max Price:
Category (Multiple ok): <% recordSet.Open("select * from categ order by name",database); Response.Write(""); %>
<% database.Close(); %>