% dim RecCnt,lng, msgbx catid = Request.Querystring("catid") prodid = Request.Querystring("prodid") lng = 0 SQL_query = "select SUMsitecat.*, SUMsitemenu.menuorder, SUMsitemenu.menuname from SUMsitecat LEFT JOIN SUMsitemenu ON SUMsitecat.prodcatmenu=SUMsitemenu.prodcatmenu where SUMsitecat.prodcatstatus=0 order by SUMsitemenu.menuorder, SUMsitecat.prodcatorder" Set RS = session("MyConn").Execute(SQL_query) if RS.eof then Set RS = Nothing RS = "" else RS.MoveFirst end if if catid <> "" then SQL_query = "select * from SUMsitecat where prodcatid=" & catid Set RSCat = session("MyConn").Execute(SQL_query) catHead = RSCat("prodcatname") catfont = RSCat("prodcatfont") catsize = RSCat("prodcatsize") cattext = RSCat("prodcattext") catid = 0 catid = RSCat("prodcatid") RSCat.close SQL_query = "select * from SUMsiteshop where prodcatid=" & catid & " and prodstatus = 0 and prodid=" & prodid & " order by prodorder" Set RSPrd = session("MyConn").Execute(SQL_query) if RSPrd.eof then set RSPrd = nothing RSPrd = "" end if end if function curency(price) prix = CDbl(price)/100 if len(prix) < 2 then prix = prix & ".00" else if instr(1,prix,".") < 1 then prix = prix & ".00" else if instr(1,right(prix,2), ".") > 0 then prix = prix & "0" end if end if end if curency = "$ " & prix end function Session("CurUrl") = Request.ServerVariables("HTTP_HOST") & Request.ServerVariables("URL") & "?" & Request.ServerVariables("QUERY_STRING") %>
![]() |
![]() |