<div>
Hi aneeshattinga,<br />
Thanks for your reply - Is it possible to rang the results returned from the select statement? <br />
Regards<br />
JamWales
</div>


Hi aneeshattinga,
Thanks for your reply - Is it possible to rang the results returned from the select statement?
Regards
JamWales

<div>
All sorted - thanks for your help.
</div>


<div>
I did n't understand your question, can you elaborate 
</div>


I did n't understand your question, can you elaborate

<div>
I suspect the author wants to use the RANK functionality with the CONTAINSTABLE() clause.
</div>


I suspect the author wants to use the RANK functionality with the CONTAINSTABLE() clause.

<div>
Hi aneeshattingal,<br />
Yes, sorry my mistake &nbsp;- I did mean RANK not RANG! Given you initial guidance, I sorted out the script and also got ranking working - thanks again for your help.<br />
Regards<br />
JamWales
</div>


Hi aneeshattingal,
Yes, sorry my mistake  - I did mean RANK not RANG! Given you initial guidance, I sorted out the script and also got ranking working - thanks again for your help.
Regards
JamWales

<div>
<div class="content wysiwyg-content">
Hi All,<br />
I've created a full text catalogue (called FT_Testit) on one table called TestTable on my MSSQL2008 database, and I'm now trying to find some asp (not asp.net) code that will allow me to perform searches against it - but I'm not having much luck!<br />
<br />
Ideally it would be a form that passed parameters to the asp search script - at the moment, I don;t even know how to reference the full text catalogue in asp!<br />
<br />
As always, any help you can offer will be greatly appreciated.<br />
<br />
Regards<br />
JamWales
</div>
</div>


Hi All,
I've created a full text catalogue (called FT_Testit) on one table called TestTable on my MSSQL2008 database, and I'm now trying to find some asp (not asp.net) code that will allow me to perform searches against it - but I'm not having much luck!

Ideally it would be a form that passed parameters to the asp search script - at the moment, I don;t even know how to reference the full text catalogue in asp!

As always, any help you can offer will be greatly appreciated.

Regards
JamWales

MSSQL2008 Full Text Search - how to create a search page in ASP, not ASP.net

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.