Re: Syntax Problem in Code using SCOPE() function

From: Chris R. Timmons (crtimmons_at_X_NOSPAM_Xcrtimmonsinc.com)
Date: 12/29/04 

Date: Tue, 28 Dec 2004 19:59:19 -0800

"=?Utf-8?B?VW1wdHk=?=" <Umpty@discussions.microsoft.com> wrote in
news:69F3EFF5-2F98-40A1-835B-738DD7821B1A@microsoft.com:

> 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' )
>
> <code snipped>
>
> conMyData = New
> SqlClient.SqlConnection("Server=Localhost;UID=sa;PWD=test;Databas
> e=Pubs")
> strSearch = "SELECT * FROM " & _
> "OPENQUERY(FileSystem, " & _
> "'SELECT RANK, FileName, VPath, Characterization " & _
> "FROM SCOPE(''" & "\ASPNetDemo\Resumes" & "'') " & _
> "WHERE FREETEXT(''" & txtSearchPhrase.Text & _
> "'') > 0 " & _
> "ORDER BY RANK DESC' )"

Umpty,

You have different slash characters in the VB code. I believe the /
character is required, not the \ character. 

-- 
Hope this helps.
Chris.
-------------
C.R. Timmons Consulting, Inc.
http://www.crtimmonsinc.com/

Relevant Pages

  • Re: Reader feelings management OR rank your chapters OR "pre-crit"
    ... So let's say you allocate number one to a character ... But if 1 scene out'a 5 are battle, that must result in a not so high "battle ... But neither rank nor rate are the right word, ... Yes, a thriller needs to be highly thrilling, but it does not need to be ...
    (rec.arts.sf.composition)
  • Re: Reader feelings management OR rank your chapters OR "pre-crit"
    ... So let's say you allocate number one to a character ... But if 1 scene out'a 5 are battle, that must result in a not so high "battle ... But neither rank nor rate are the right word, ... Yes, a thriller needs to be highly thrilling, but it does not need to be ...
    (rec.arts.sf.composition)
  • Re: Inheritance error: class Foo has no attribute "bar"
    ... character but I keep getting errors. ... I want to "redefine" some attributes from the base class so I can use them ... to help determine the rank. ... and the subclass is called "Marine"): ...
    (comp.lang.python)
  • Re: Design: Need help with character creation disads
    ... But perhaps it would be better to just call it "Protective", without a category, so that the Flaw always makes the character protective against exactly those three: Women, children and pet animals. ... Normally if a character has a level in a rank subskill, such as Intelligence Rank, Police Rank or Military Rank, he is assumed to be retired from that organization, and therefore his "clout" only equals his level in that subskill. ...
    (rec.games.frp.advocacy)
  • Re: Inheritance error: class Foo has no attribute "bar"
    ... character but I keep getting errors. ... I want to "redefine" some attributes from the base class so I can use them ... to help determine the rank. ... and the subclass is called "Marine"): ...
    (comp.lang.python)