Recordset Hit Count

Results 1 to 2 of 2

Thread: Recordset Hit Count

  1. #1
    Venson Kuchipudi Guest

    Default Recordset Hit Count

    Is is possible to get the actual hit count of SELECT statement WHERE criteria in a recordset. I am trying to show the user how many times a particular word was found in a SQL server database rather than the number of records the word was found in.<BR><BR>In addition I would like to highlight these words when I display the results.<BR><BR>Anyone done this. I know many search engines do this and so does Index Server for web documents.

  2. #2
    Jim Ritter Guest

    Default RE: Recordset Hit Count

    Query using <BR>- select * from tblname where "" CONTAINS &#039your words&#039-<BR><BR>Then on the records returned, use regular expressions (RE) to get the exact count of the word your looking for. Then use DHTML to highlight the word found.<BR><BR>Hope this helps!<BR>Jim<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts