%@ Language=VBScript %> <%Option Explicit%> <% if session("LastNameOnTop") & "" = "" AND session("UserID") & "" <> "" then%> <%end if dim oRs, oConn, SQL, i, RecipCategs, Data, Dataexist dim ChefData, ChefDataExist, ChefID, PageNo, tens dim starting, ending, thisstyle, totalRows, totalPages RecipCategs = Application("RecCategs"&lang) ChefID = Request.Form("ChefID") PageNo = Request("PageNo") : if PageNo & "" = "" then PageNo = 1 tens = Request("tens") : if tens & "" = "" then tens = 1 if lang = "GR" then templang = "" else templang = "EN" if ChefID & "" = "" then dim errmsg Response.Redirect("error.asp") end if set oConn = Server.CreateObject("ADODB.Connection") oConn.open Application("Constr") set oRs = Server.createObject("ADODB.Recordset") SQL = "ShowRecipebyChef " & ChefID & ", " & lang & "," & PageSize & "," & PageNo oRs.open SQL, oConn, 3,1,1 if oRs.EOF = false then Dataexist = 1 totalRows = oRs("TotalRecs") Data = oRs.GetRows() totalPages = totalRows \ PageSize if totalRows mod PageSize > 0 then totalPages = totalPages + 1 end if oRs.close SQL = "Select ChefID, ChefName" & lang &", ChefPhoto, ChefCV"&lang&" from Chefs where ChefID=" & ChefID oRs.open SQL, oConn, 3,1,1 if oRs.EOF = false then ChefData = oRs.GetRows() ChefDataExist = 1 end if oRs.close 'Response.Write "" starting = ((tens-1)*10)+1 : ending = starting + 9 GoToPage = "RecChefsAll.asp" menu = "2" %>