I am trying to use the Indexing Service to search for content from a folder on my web site called "products".
Here are the details...
In the "<asp:SqlDataSource" command which begins on line 37 in Search99.aspx, the "SelectCommand" contains a Scope parameter. If I leave the Scope as "Scope()" the program works, however it searches the entire website.
If I add "' DEEP TRAVERSAL OF ("/products") '" to the Scope() then the program fails with message
" Parser Error Message: The server tag is not well formed."
Is this a syntax error or is there something I'm missing?
Also can we search more than one directory in "Scope parameter"?
Any help would be appreciated ...
Rob
search99.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Search99.aspx.cs" Inherits="Search9" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server"></script>
<html xmlns="http://www.w3.org/1999/xhtml"><head id="Head1" runat="server"><script src="/scripts/dateLastMod.js" type="text/javascript"></script><link href="/App_Themes/Default/default.css" rel="stylesheet" type="text/css" /><link href="/App_Themes/Default/tabs.css" rel="stylesheet" type="text/css" /><title>Home</title></head><body><form id="form1" runat="server"><a name="top"></a><div id="main"> <div id="netid" style: align="center"><img src="/graphics/network.png" /></div> <div id="header" style: align="center"><img src="/graphics/banner.png" /></div> <div id="topnav"> <ul class="tab"> <li class="selected"><a href="/default.aspx"><img src="/graphics/home.png" alt="Home" />Home</a></li> <li><a href="/Intel/default.aspx"><img src="/graphics/intel.png" alt="Intelligence" />Int</a></li> <li><a href="/OPs/default.aspx"><img src="/graphics/ops.png" alt="Operations" />OPs</a></li> <li><a href="/Tools/default.aspx"><img src="/graphics/tools.png" alt="Tools" />Tools</a></li> <li><a href="/Security/default.aspx"><img src="/graphics/security.png" alt="Security" />Security</a></li> <li><a href="/Admin/default.aspx"><img src="/graphics/admin.png" alt="Administration" />Admin</a></li> <li><a href="/Search/default.aspx"><img src="/graphics/search.png" alt="Search" />Search</a></li> <li><a href="/GenInfo/default.aspx"><img src="/graphics/info.png" alt="General Info" />General Info</a></li> </ul> </div> <div id="breadCrumbs" class="breadCrumbs"><a href="/default.aspx">CDI Home</a></div> <div id="clientNav"> </div> <div id="content" class="content"> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Provider=MSIDXS;Data Source=web" SelectCommand="Select DocTitle, path, vpath, filename, write, characterization, ilcountryname, ilagency, ildoctype, ildoccategory, ilkeyword, ilsummary, idcAttachmentSize FROM SCOPE(' DEEP TRAVERSAL OF ("/products") ') WHERE CONTAINS(ildoctype, 'BRIEF') AND Path NOT LIKE '%search_excluded%' order by rank desc" ProviderName="System.Data.OleDb"> </asp:SqlDataSource> <asp:ListView ID="productsList" runat="server" DataSourceID="SqlDataSource1"> <LayoutTemplate> <ul> <asp:PlaceHolder ID="itemPlaceHolder" runat="server" /> </ul> </LayoutTemplate> <ItemTemplate> <% int cnt = 0; %> <% cnt += 1; %> <a href='<%# DataBinder.Eval(Container.DataItem, "vpath") %>'><%# DataBinder.Eval(Container.DataItem, "DocTitle") %></a> <br />
<asp:Label ID="Label2" runat="server" Text="Agency: " class="searchText" /> <%# DataBinder.Eval(Container.DataItem, "ilagency")%> <br /> <asp:Label ID="Label3" runat="server" Text="Countries Discussed: " class="searchText" /> <%# DataBinder.Eval(Container.DataItem, "ilcountryname")%> <br /> <asp:Label ID="Label4" runat="server" Text="Summary: " class="searchText" /> <%# DataBinder.Eval(Container.DataItem, "ilsummary")%> <br /><br /> <asp:Label ID="Label5" runat="server" Text="Time and Date Posted: " class="searchText" /> <%# DataBinder.Eval(Container.DataItem, "write")%> <br /> <asp:Label ID="Label6" runat="server" Text="File Size: " class="searchText" /> <%# DataBinder.Eval(Container.DataItem, "idcAttachmentSize")%> <asp:Label ID="Label7" runat="server" Text=" Kb" class="searchText" /> <br /><hr /><br />
</ItemTemplate> <EmptyDataTemplate> <h4> Sorry - no products found. </h4> </EmptyDataTemplate> </asp:ListView> <asp:DataPager PageSize="2" runat="server" PagedControlID="productsList"> <Fields> <asp:NextPreviousPagerField ButtonType="Button" FirstPageText="First Page" LastPageText="Last Page" NextPageText="Next Page" PreviousPageText="Previous Page" ShowFirstPageButton="True" ShowLastPageButton="True" /> </Fields> </asp:DataPager> <br /><br /> <asp:DataPager ID="DataPager1" PageSize="2" runat="server" PagedControlID="productsList"> <Fields> <asp:NumericPagerField ButtonType="Button" NextPageText="Next Page" PreviousPageText="Previous Page" /> </Fields> </asp:DataPager>
</div> <div id="footer" class="footer"> <div id="footLeft"> <div> <script language="JavaScript">document.write("Publication Date: " + date_lastmodified());</script> </div> </div> <div id="footMiddle"> <div><a href="#top">Top</a></div> </div> <div id="footRight"> <div><a href="#">Important Notices </a></div> </div> </div> </div></form></body></html>
search99.aspx.cs
using System;using System.Collections;using System.Configuration;using System.Data;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;
public partial class Search9 : System.Web.UI.Page{ protected void Page_Load(object sender, EventArgs e) { }}