Hi all...
I did a search form...
when user write in the form: Moscow
The form give him all the results with the word Moscow

But when he write Moscow London the result is 0 entries...

BUT in the table we can find Moscow to London

And the search ignores this. cuz he search's full frase...

What should i do th show the user Moscow to London if he search Moscow london...

Here's the code:

Code:

    strSQL = "SELECT marsh, polnyi, id " _
        & "FROM Question " _
        & "WHERE marsh LIKE '%" & Replace(strpoisk, "'", "''") & "%' " _
        & "OR polnyi LIKE '%" & Replace(strpoisk, "'", "''") & "%' " _
        & "ORDER BY id;"

Sorry for my English... and thank for your help!

... my english is terrible !

strSQL = "SELECT marsh, polnyi, id " _
        & "FROM Question WHERE (marsh LIKE "

Dim Pos
Pos = 1
While Pos > 0
Pos = InStr(1, strpoisk," ")
If Pos = 0 Then


strSQL = strSQL & "'%" & strpoisk & "%')"

Else

strSQL = strSQL & "'%" & Mid(strpoisk,1,Pos) & "%' OR polnyi LIKE "
strpoisk = Mid(strpoisk,Pos+1,len(strpoisk))
End If
Wend


strSQL = strSQL & "ORDER BY id;"

response.write strSQL

try this code !

Steweb





Visit my web site !
www.steweb.net