VBScript SQL Server Search Script
am 10.02.2005 15:56:01 von thomas.burrowHi,
Does anyone know of a good sql server asp vbscript search script? I
am looking to have multiple word searched with results ordered by
relevance etc.
Thanks
Hi,
Does anyone know of a good sql server asp vbscript search script? I
am looking to have multiple word searched with results ordered by
relevance etc.
Thanks
You'd want to handle this with SQL, not with VBScript, like such as in a
stored procedure. Once you have that down, then it'd be a matter of using
whatever method you're using to display the results. If that's VBScript,
just think about how to display a recordset. It'll just so happen that the
recordset is contains search results data.
I'd try inquiring in a SQL newsgroup, such as
microsoft.public.sqlserver.programming
Ray at work
"TomyB"
news:13dada3.0502100656.61fa6959@posting.google.com...
> Hi,
>
> Does anyone know of a good sql server asp vbscript search script? I
> am looking to have multiple word searched with results ordered by
> relevance etc.
>
> Thanks
I have found a solution using sql full text indexing - works just like
the indexing server on the sql database!
Thanks