to count the occurence of a particular word in search of an indexing database server

[AquarianMermaid]

how to count the occurence of a particular word in search of an indexing database server

[AquarianMermaid]

hi,
i am trying to query the indexing database server. in the serach i type a word for eg. "now" , so i need the result set to be ordered in a way that the document which has maxOccurrence of "now" is returned first and the rest documents later. that is, they should be ordered from ""maxOccurence" to "minOccurence"

[jhardman]

I wish you could just do it in the SQL, but failing that, you will need to do it programmatically.
1- search the db so you are getting the set of every record with that string
2- send each to a function that counts ( I would use the instr() function in a loop)
3- sort the list according to that count
That said, ASP won't do a good job of that unless you are getting ~10 hits from the db query.

Jared