%@ Language=VBScript %> <%Option Explicit%> <% if session("LastNameOnTop") & "" = "" AND session("UserID") & "" <> "" then%> <%end if dim CategID, SearchStr, MainCategs, MainCategDescr, SubCategs, SubCategDescr, a, i dim oRs, oConn, SQL, DataExist, MainDataExist, ShowLeft, LeftProdID dim tmplang, PageNo, totalRows, Data, totalPages, tens, thisstyle dim starting, ending, FullSearch dim ProdPhArray, ProdPhoto set oConn = Server.CreateObject("ADODB.Connection") oConn.open Application("ConStr") set oRs = Server.CreateObject("ADODB.Recordset") CategID = Request.Form("SearchCategID") SearchStr = trim(Replace(Request.Form("SendSearchStr"),"'","''")) : if SearchStr & "" = "" then SearchStr = trim(Replace(Request.Form("SearchStr"),"'","''")) FullSearch = Request.Form("FullSearch") PageNo = Request("PageNo") : if PageNo & "" = "" then PageNo = 1 tens = Request("tens") : if tens & "" = "" then tens = 1 if lang = "GR" then tmplang = "" else tmplang = "EN" if SearchStr & "" <> "" OR CategID & "" <> "" then SQL = "SearchProducts ' " & SearchStr & " ','" & CategID & "','"& tmplang &"', '" & session("UserID") & "', " & PageSize & ", " & PageNo oRs.open SQL, oConn, 0, 1, 1 if oRs.state=0 then oRs.open SQL, oConn, 3, 1, 1 if oRs.EOF = false then totalRows = oRs("TotalRecs") if totalRows = 0 then MainDataExist = 0 else totalRows = oRs("TotalRecs") MainDataExist = 1 Data = oRs.GetRows() totalPages = totalRows \ PageSize if totalRows mod PageSize > 0 then totalPages = totalPages + 1 end if oRs.close else MainDataExist = 0 end if starting = ((tens-1)*10)+1 : ending = starting + 9 GoToPage = "search.asp?SearchStr=" & SearchStr & "&CategID=" & CategID menu = "1" %>