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
Unsolved 
