Rating a SQL query??

Results 1 to 3 of 3

Thread: Rating a SQL query??

  1. #1
    Big Al Guest

    Default Rating a SQL query??

    What I have got is a query that runs though an array, checking all the keywords agist the DB<BR>What I want is a way to register which pages had a positive search and how many key words were found in each page? any ideas.<BR><BR>==================================== =============================<BR>str = request.form ("user_subject")<BR>str = replace(str,"the ","")<BR>MyArray = Split(str) <BR>number = Ubound(MyArray)+1<BR>response.write number<BR><BR>onedimarray = split(str, " ", number)<BR><BR>SQL = "SELECT subject, body, date2 FROM press WHERE"<BR>For intcounter = 0 to Ubound(MyArray)<BR>response.write onedimarray(intcounter)<BR>SQL = SQL & " body LIKE &#039%" & onedimarray(intcounter) & "%&#039 OR"<BR>next<BR>SQL = SQL & " body LIKE &#039%" & onedimarray(0) & "%&#039"<BR> objCon.Execute(SQL)<BR>=========================== ======================================

  2. #2
    Join Date
    Dec 1969

    Default RE: Rating a SQL query??

    Did you want to include the first word of the array twice?

  3. #3
    Big Al Guest

    Default Nope!

    I have delt with that thanks but any idea how to rate the results

Posting Permissions

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