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
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