Writing script for a search engine

[spacehawk]

I have a site that uses one asp page to produce 1100 unique pages from text files and corresponding database info.  I would like to develop a search function that would check the text files for the designated word and return a list of corresponding titles (as links) from a database table.

 

[NickBulka]

This is exactly what Index Server is for. <p>nick bulka<br><a href=mailto:nick@bulka.com>nick@bulka.com</a><br><a href= > </a><br>

 

[spacehawk]

Can I return all but the last 4 characters in a string?&nbsp;&nbsp;How would I do that.

 

[sbind77]

Hi All

I need to write a website search for my application

The following is the code I write for the search facility.
but its not working.Its not returning any error, but its not returning any results.I don'tknow whats the problem with the code.It will be great if anyone helps me

set con=server.createobject( &quot;adodb.Connection&quot; )
con.Open &quot;provider=msidxs&quot;
mySQL = &quot;SELECT Characterization,DocTitle,Path &quot; &_
&quot;FROM SCOPE('DEEP TRAVERSAL OF &quot;&quot;/(mywebsitename)&quot;&quot;') &quot;' &_
'&quot;WHERE FREETEXT(Contents, '&quot; & search & &quot;') > 0 &quot; &_
'&quot;ORDER BY Rank DESC&quot;

Set RS = Con.Execute( mySQL )

Thanks
Balachandar Thank You
sbind77