Hi All I need to write a website

[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( "adodb.Connection" )
con.Open "provider=msidxs"
mySQL = "SELECT Characterization,DocTitle,Path " &_
"FROM SCOPE('DEEP TRAVERSAL OF ""/(mywebsitename)""') "' &_
'"WHERE FREETEXT(Contents, '" & search & "') > 0 " &_
'"ORDER BY Rank DESC"

Set RS = Con.Execute( mySQL )

Thanks
Balachandar Thank You
sbind77

 

[CDN]

[tt]Have you tried simply doing: Select * [/tt]

​