Tekst søgning med relevans point

is this to be used in Access or maybe ASP?

Hvordan vil søgekriteriet se ud for ovenstående resultat? Jeg er ikke helt med på hvordan du ønsker det?

Hi thomas
I think montago want to be able to enter thre criteria and count how many hits he gets on each row. I dont think its necessary using the Alias column though.

Jeg har løst problemet selv:

If Request("text") <> "" then
    session("text") = Request("text")
        Q_arr = split(Request("text"))
        strSQL = "Select Count(*) as maxValue,Video_ID,Song_ID,Artist,Title,Year from "
        for each x in Q_arr
            sqlnum = sqlnum + 1
            if sqlnum > 1 then
                strSQL = strSQL & " UNION ALL (Select * from Videos where (Artist & Title & Year) like '%"& X &"%')"
            else
                strSQL = strSQL & "(Select * from (Select * from Videos where (Artist & Title & Year) like '%"& X &"%')"
            end if
        next
        strSQL = strSQL & " order by Title) group by Video_ID,Song_ID,Artist,Title,Year order by Count(*) desc, Artist, Title asc"
        Session("SQL") = strSQL
End if

    Set rs = conn.execute(Session("SQL"))
    set rs_cnt = conn.execute("Select count(*) as numResults from (" & Session("SQL") & ")")
   
    maxValue = cint(rs("maxValue"))
    Do while not rs.eof
    Match    = "Matched: " & FormatNumber(cint(rs("maxValue"))/maxValue*100,2) & "%"
    rs.movenext
    loop

ok, lukker du så ikke lige spm, så andre ikke spilder tid i forsøg på at hjælpe?

pfh tak :o)

så pyt da

:o)