Keyword Search and return match percentage

Reply

Join Date: Jul 2006
Posts: 1
Reputation: yawboon is an unknown quantity at this point 
Solved Threads: 0
yawboon yawboon is offline Offline
Newbie Poster

Keyword Search and return match percentage

 
0
  #1
Jul 3rd, 2006
Hi , I am 1st time in this forum. i need to do a search using asp . The search result will return the keyword match percentage with the word in database. example: http://www.newport.com/searchresults...Opto-Mechanics

i am running out of time and still cannot find any resources on the web. Does anyone know how to do this and maybe can provide me some resources. Thanks a lot....
Reply With Quote Quick reply to this message  
Join Date: Jun 2005
Posts: 3
Reputation: Grumblybum is an unknown quantity at this point 
Solved Threads: 0
Grumblybum Grumblybum is offline Offline
Newbie Poster

Re: Keyword Search and return match percentage

 
0
  #2
Jul 11th, 2006
Originally Posted by yawboon
Hi , I am 1st time in this forum. i need to do a search using asp . The search result will return the keyword match percentage with the word in database. example: http://www.newport.com/searchresults...Opto-Mechanics

i am running out of time and still cannot find any resources on the web. Does anyone know how to do this and maybe can provide me some resources. Thanks a lot....
I have never done this but..

If you do a quick reccord count and store it in a variable,
Dim mySQL
mySQL = "Select Count(*) AS myTotal FROM yourdata"
Dim myRS
Set myRS = Server.CreateObject("ADODB.RecordSet")
myRS.Open mySQL, myConn
Record_size = myRS("myTotal")

and then code your search to return the number of records,
Dim iRecordCount
iRecordCount = objPagingRS.RecordCount

Then simple math equasion with your variables should give you the percentage

BTW the database search samples at http://www.asp101.com/ have some very well commented scripts that do this sort of thing

Regards

Roy
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC