Database Full-Text search

Results 1 to 3 of 3

Thread: Database Full-Text search

  1. #1
    Dominik Moosbrugger Guest

    Default Database Full-Text search

    is it possible to search a database with asp like index server (ms) does it with a bunch of directories? <BR><BR>or is ADO only capable of searching one column at a time?

  2. #2
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: Database Full-Text search

    What do you mean by "Search an entire database?" ADO can search more than one column at a time. Well, to be more clear, SQL allows you to query on more than one column at a time. You can do:<BR><BR>SELECT * FROM Table1 WHERE Column1 = &#039something&#039 AND Column2 = &#039SomethingElse&#039<BR><BR>I don&#039t know, though, what you are exactly asking. Does this clear up anything, or just muddy the watters? :)

  3. #3
    Dominik Moosbrugger Guest

    Default RE: Database Full-Text search

    thanks, this helped me out. i just had the problem that my "something" and my "something else" are the same. i tried to do it this way: WHERE (Column1 AND Column2) LIKE &#039something&#039<BR><BR>didn&#039t work. well. okay, I now compare each of my Columns with &#039something&#039 and it works. <BR><BR>thanks again. bye. &8-))

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •