% ' Get and validate linkid Dim linkid linkid = Request.Querystring("linkid") ' Basic validation - must be numeric and positive If Not IsNumeric(linkid) Or CLng(linkid) < 1 Then Response.Redirect("displayknowledgebase.asp") Response.End End If ' Get the article details using parameterized query Dim strSQL, rs strSQL = "SELECT kb.*, app.appname " &_ "FROM knowledgebase kb " &_ "INNER JOIN applications app ON kb.appid = app.appid " &_ "WHERE kb.linkid = ? AND kb.isactive = 1" Set rs = ExecuteParameterizedQuery(objConn, strSQL, Array(CLng(linkid))) If rs.EOF Then rs.Close Set rs = Nothing objConn.Close Response.Redirect("displayknowledgebase.asp") Response.End End If %>
<% Dim theme theme = Request.Cookies("theme") IF theme = "" THEN theme="bg-theme1" END IF %>