Søgning i DB
Jeg har lavet denne søgning som Splitter strKeyword, hvis brugeren skriver flere ord i søgefeltet.Nu ville jeg gerne at scriptet først søger på hele strKeyword, altså uden at splitte det og derefter splitter.
Lidt Kode:
strKeyword = split(Trim(Request.Form("Keyword")), " ")
Select Case UBound(strKeyword)
Case "0"
strSQL = "select * from power where description like '%" & strKeyword(0) & "%' order by titel desc"
Case "1"
strSQL = "select * from power where description like '%" & strKeyword(0) & "%' and description like '%" & strKeyword(1) & "%' order by titel desc" '2 ord i søgningen
Case "2"
strSQL = "select * from power where description like '%" & strKeyword(0) & "%' and description like '%" & strKeyword(1) & "%' and description like '%" & strKeyword(2) & "%' order by titel desc" '3 ord i søgningen
Case Else
strSQL = "select * from power where description like '%" & strKeyword(0) & "%' and description like '%" & strKeyword(1) & "%' and description like '%" & strKeyword(2) & "%' order by titel desc" 'mere end 3 ord i søgningen
End Select
