Re: contains(t 3) or contains(???)

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: John Kane (jt-kane_at_comcast.net)
Date: 08/09/04

  • Next message: John Kane: "Re: Full text search writing messages in eventlog" 
    Date: Sun, 8 Aug 2004 21:32:15 -0700

    You're welcome, Andreas,
    One possible solution, depending upon the OS platform you have SQL Server
    installed on (post @@version), and how you display the film titles to your
    users, is to embed html tags next to or touching or in contact with the
    leading & trailing single letters, such as <b>M I B<\b> as this could solve
    you problem with Win2K. If you're using WinXP or Win2003, this solution will
    not work, and I'd recommend adding a special keyword or phrase to search on
    for these known single letter movie titles, such as MIB or T3 and capture
    these special single letter combinations when imputed from the searcher.
    Also, if you want you can email me for non-MSSearch solutions as I have
    developed some FTS solutions (using a movie database too) for a book project
    I've researched & developed over the past 2 years....

    Thanks,
    John

    "Andreas" <nospam@nospam.com> wrote in message
    news:uXNB7mRfEHA.236@tk2msftngp13.phx.gbl...
    > Completely right. There are some data in the database with names like "T
    3"
    > or "M I B". The contains ('"T 3"') or contains ('"M I B"') gives exactly
    > 7619 error msg. Any workarounds?
    >
    > Thanks, Andreas
    >
    >
    >
    >
    > "John Kane" <jt-kane@comcast.net> schrieb im Newsbeitrag
    > news:uVdDKT8eEHA.704@TK2MSFTNGP09.phx.gbl...
    > > Andreas,
    > > Unfortunately, no as the SQL Server/MSSearch wordbreaker does not allow
    > > customization of wordbreaking characters.
    > > If the search characters are anything except single letters &/or single
    > > digit numbers, you can of course use a search phrase, i.e., multiple
    words
    > > contained within double quotes.
    > >
    > > Is your concern the ability to search on multiple single letters/digits
    > > without getting error msg 7619" "The query contained only ignored
    words"?
    > >
    > > Regards,
    > > John
    > >
    > >
    > > "Andreas" <nospam@nospam.com> wrote in message
    > > news:uZ6Ss07eEHA.3428@TK2MSFTNGP11.phx.gbl...
    > > > Hi,
    > > >
    > > > I am sure that my question was posted before but cannot find anything.
    > So
    > > > here it is again:
    > > > 1. Is there a way to search for "T 3" or "???" using contains without
    > > > changing the noise-text file?
    > > > 2. No kind of escape character for the space in "T 3"?
    > > >
    > > > Any help is really appreciated!
    > > >
    > > > Thanks, Andreas
    > > >
    > > >
    > >
    > >
    >
    >

  • Next message: John Kane: "Re: Full text search writing messages in eventlog"