<% productName = request.Form("ProductId") if productName="Enter keyword here..." then productName = " " end if set objConn=Server.CreateObject("ADODB.Connection") objConn.Provider="Microsoft.Jet.OLEDB.4.0" objConn.Open Server.MapPath("VertexDB.mdb") SQL="SELECT ProductId,ProductCategory,ProductName,ProductOverview,ImagePath,PdfPath FROM [ProductMaster] where ProductStatus=true and ProductCategory='Packaging Testing Machine' and ProductName like "&"'%"& productName &"%'" 'response.Write(sql) Set objRec = Server.CreateObject ("ADODB.Recordset") objRec.Open SQL,objConn do while NOT objRec.eof %>

<%=objRec("ProductName")%>

<%=Trim(objRec("ProductOverview"))%>

" alt="image" width="210" height="215" />
<% objRec.MoveNext Loop %>