%@ Language=VBScript %> <% SearchLinkName = Request("SearchJobName") OrderBy = Request.QueryString("OrderBy") if OrderBy = "" then OrderBy = "link_industryID, link_name" end if sqlQuery = "select * from ResourceLinks where link_industryID = 1" if (SearchLinkName <> "") then sqlQuery = sqlQuery & "AND link_name = '" & SearchLinkName & "' " end if sqlQuery = sqlQuery & " ORDER BY " & OrderBy 'get document list set rs = Application("dataConn").execute(sqlQuery) %>