Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hi All I need to write a website

Status
Not open for further replies.

sbind77

Programmer
Oct 2, 2001
29
US
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
 
[tt]Have you tried simply doing: Select * [/tt]

YGMS_100x100.jpg

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top