[prev in list] [next in list] [prev in thread] [next in thread] 

List:       ms-atl
Subject:    Re: search engine
From:       Luis Abreu <luisabreu () NETMADEIRA ! COM>
Date:       2001-04-30 13:40:10
[Download RAW message or body]


Ok. I'll give it a try. Thanks for your help.

Luis Abreu

> -----Original Message-----
> From: ATL - Active Template Library [mailto:ATL@DISCUSS.MICROSOFT.COM]
On
> Behalf Of Dee Holtsclaw
> Sent: segunda-feira, 30 de Abril de 2001 14:14
> To: ATL@DISCUSS.MICROSOFT.COM
> Subject: Re: search engine
>
> Having written such an animal I can tell you that the query ends up
being
> a
> morass of nested joins. Of course, it looks more complicated than it
> really
> is. Since you're after multiple words, you need a query which joins
result
> tables based on the joining condition of the words entered. For 'AND'
you
> simply use 'AND' in the WHERE clause. For the OR's you construct two
> select
> statements and UNION them together. A 'NEAR' you treat as an 'AND' and
> manually remove entries from the result set where the 'NEAR' match is
too
> far away. For indexing, I suggest a single word index storing
reference
> information for the source of the word. Eliminate the noise words
(like
> 'A',
> 'AN', 'THE', etc. -- I don't know the Portuguese equivalents) and
match
> them
> as needed for quoted strings in the post processing of the result set
> (while
> handling NEAR).
>
> If you need it, I could try to dig up the project I did this in and
clean
> it
> up for you. I'm kinda strapped on time so I don't know if I could get
it
> too
> you any quicker that you could hack this out yourself though...
>
> Good Luck!
>
> Sincerely,
> Lawrence "Dee" Holtsclaw
> Senior Software Engineer
> Sunbelt Software Solutions, Inc.
> mailto:dee@sunbeltsoft.com
>
>
> > -----Original Message-----
> > From: ATL - Active Template Library
[mailto:ATL@DISCUSS.MICROSOFT.COM]On
> > Behalf Of Luis Abreu
> > Sent: Sunday, April 29, 2001 6:31 AM
> > To: ATL@DISCUSS.MICROSOFT.COM
> > Subject: Re: search engine
> >
> >
> > The table comes from a table. Doesn't the English query only works
for
> > English? I'm building my tables for Portuguese.
> >
> > I just would like some pointers for doing something like Boolean
> > searches, or something like MSDN does when you do a search on it.
> >
> > BTW, thanks for your reply.
> >
> > Luis Abreu
> > > -----Original Message-----
> > > From: ATL - Active Template Library
[mailto:ATL@DISCUSS.MICROSOFT.COM]
> > On
> > > Behalf Of Mark Billingham
> > > Sent: domingo, 29 de Abril de 2001 10:51
> > > To: ATL@DISCUSS.MICROSOFT.COM
> > > Subject: Re: search engine
> > >
> > > Have you looked at the English Query engine that comes with SQL
server
> > ?.
> > > You could also consider Index Server if the data does not have to
be
> > held
> > > in
> > > SQL server.
> > >
> > > -----Original Message-----
> > > From: ATL - Active Template Library
> > [mailto:ATL@DISCUSS.MICROSOFT.COM]On
> > > Behalf Of Luis Abreu
> > > Sent: 28 April 2001 12:01
> > > To: ATL@DISCUSS.MICROSOFT.COM
> > > Subject: OT: search engine
> > >
> > > Hello all, and sorry for the OT again. However, I've posted this
in
> > > other groups and had no response, so why not give it a try here...
> > >
> > > I was wondering if someone could provide me with some feedback for
the
> > > following situation:
> > > - I have an input box (type text) where a user can enter any
> > combination
> > > of names.
> > > - After introducing the names, I must do a search on a sql server
db
> > for
> > >  obtaining data.
> > >
> > >  Now, I really would appreciate if someone pointed me to a good
url
> > that
> > >  talked about doing searches and/or building search engines.
> > >
> > >  I'm not looking for solutions that use LIKE keyword in a stored
> > >  procedure cause this does not solve the problem of multiple
words.
> > >
> > > TIA,
> > > Luis Abreu
> > >
> > > ----------------------------------------------------------------
> > > Users Guide http://msdn.microsoft.com/workshop/essentials/mail.asp
> > > contains important info. Save time, search the archives at
> > > http://discuss.microsoft.com/archives/index.html .
> > > To unsubscribe, mailto:ATL-signoff-request@DISCUSS.MICROSOFT.COM
> > >
> > > ----------------------------------------------------------------
> > > Users Guide http://msdn.microsoft.com/workshop/essentials/mail.asp
> > > contains important info. Save time, search the archives at
> > > http://discuss.microsoft.com/archives/index.html .
> > > To unsubscribe, mailto:ATL-signoff-request@DISCUSS.MICROSOFT.COM
> >
> > ----------------------------------------------------------------
> > Users Guide http://msdn.microsoft.com/workshop/essentials/mail.asp
> > contains important info. Save time, search the archives at
> > http://discuss.microsoft.com/archives/index.html .
> > To unsubscribe, mailto:ATL-signoff-request@DISCUSS.MICROSOFT.COM
>
> ----------------------------------------------------------------
> Users Guide http://msdn.microsoft.com/workshop/essentials/mail.asp
> contains important info. Save time, search the archives at
> http://discuss.microsoft.com/archives/index.html .
> To unsubscribe, mailto:ATL-signoff-request@DISCUSS.MICROSOFT.COM

----------------------------------------------------------------
Users Guide http://msdn.microsoft.com/workshop/essentials/mail.asp
contains important info. Save time, search the archives at
http://discuss.microsoft.com/archives/index.html .
To unsubscribe, mailto:ATL-signoff-request@DISCUSS.MICROSOFT.COM

[prev in list] [next in list] [prev in thread] [next in thread]