Syntax Problem in Code using SCOPE() function

From: Umpty (Umpty_at_discussions.microsoft.com)
Date: 12/28/04 

Date: Tue, 28 Dec 2004 08:25:04 -0800

Trying to use Microsoft Indexing Service.

Here is my code using SQL Query Analyzer, which works perfectly.

SELECT * FROM
OPENQUERY(FileSystem,
        'SELECT RANK, FileName, Characterization
        FROM SCOPE(''"/ASPNetDemo/Resumes"'')
        WHERE FREETEXT(''Baione'') > 0
        ORDER BY RANK DESC' )

but... when I put this code in the script in my ASPX page, apparently the
syntax does not work. The following is all of my code.

Sub btnSearch_Click(ByVal s As Object, ByVal e As EventArgs)
        Dim conMyData As SqlClient.SqlConnection
        Dim strSearch As String
        Dim cmdSearch As SqlClient.SqlCommand
        Dim dtrSearch As SqlClient.SqlDataReader
        Dim x As String
        x = "'/ASPNetDemo/Resumes'"

        conMyData = New
SqlClient.SqlConnection("Server=Localhost;UID=sa;PWD=test;Database=Pubs")
        strSearch = "SELECT * FROM " & _
        "OPENQUERY(FileSystem, " & _
        "'SELECT RANK, FileName, VPath, Characterization " & _
        "FROM SCOPE(''" & "\ASPNetDemo\Resumes" & "'') " & _
        "WHERE FREETEXT(''" & txtSearchPhrase.Text & _
        "'') > 0 " & _
        "ORDER BY RANK DESC' )"

        cmdSearch = New SqlClient.SqlCommand(strSearch, conMyData)
        conMyData.Open()
        Try
            dtrSearch = cmdSearch.ExecuteReader()
            lblResults.Text = "<ul>"
            While dtrSearch.Read
                lblResults.Text &= "<li> (" & dtrSearch("RANK") / 10 & "%) "
                lblResults.Text &= "<a href=""" &
dtrSearch("VPath").ToString()
                lblResults.Text &= """>"
                lblResults.Text &= dtrSearch("FileName") & "</a><br>"
                lblResults.Text &= dtrSearch("Characterization")
                lblResults.Text &= "<p>"
            End While
        Catch ex As Exception
            lblResults.Text = "Please rephrase your query"
        End Try
        conMyData.Close()
    End Sub

Any help in pointing out the correct syntax using the SCOPE function would
be greatly appreciated.

Thanks

Relevant Pages

  • Syntax Question
    ... Trying to use Microsoft Indexing Service. ... Here is my code using SQL Query Analyzer, ... Sub btnSearch_Click ... Any help in pointing out the correct syntax using the SCOPE function would ...
    (microsoft.public.dotnet.academic)
  • Re: repplace char in $1
    ... i tried to replace space with other chars in the first field: ... i have found the correct syntax: ... gsub replace all space by ' ' and sub replace the delimiter at end ...
    (comp.lang.awk)
  • Re: repplace char in $1
    ... i tried to replace space with other chars in the first field: ... i have found the correct syntax: ... gsub replace all space by ' ' and sub replace the delimiter at end ...
    (comp.lang.awk)
  • Re: ClearContents does not work...
    ... It is the correct syntax and the correct command. ... only a single new workbook. ... Sub AAA ...
    (microsoft.public.excel.programming)