søge i db

That was easy to answer

where ís you SQL?

brug AND og ikke OR =)

Ups, her er den.

sstring = split(strSearch," ")   

strSQL = "SELECT * " _
        & "FROM links " _
        & "WHERE "

for i = lbound(sstring) to ubound(sstring)
  if strWHERE <> "" then strWHERE = strWHERE & " AND "
  strWHERE = strWHERE & " title LIKE '%" & sstring(i) & "%' " _
  & " OR description LIKE '%" & sstring(i) & "%' "
next

strSQL1 = strSQL & strWHERE & " ORDER BY title;"

BEMÆRK PARANTESER OMKRING...

for i = lbound(sstring) to ubound(sstring)
  if strWHERE <> "" then strWHERE = strWHERE & " AND "
  strWHERE = strWHERE & " (title LIKE '%" & sstring(i) & "%' " _
  & " OR description LIKE '%" & sstring(i) & "%') "
next

Har jeg nu prøver og så siger den bare
En sætning var ventet
db_sog.asp, line 37
(for i = lbound(sstring) to ubound(sstring)

Hvad jeg mente var: Jeg har sat paranteser ind i din "strWHERE = " - linie ...

(title LIKE '%" & sstring(i) & "%' " _
  & " OR description LIKE '%" & sstring(i) & "%')

På den bmåde får du en række enten eller som ALLE skal være opfyldt...

strSQL = "SELECT * " _
        & "FROM links " _
        & "WHERE 1"

for i = lbound(sstring) to ubound(sstring)
  if strWHERE <> "" then strWHERE = strWHERE & " AND "
  strWHERE = strWHERE & " (title LIKE '%" & sstring(i) & "%' " _
  & " OR description LIKE '%" & sstring(i) & "%') "
next

jan2001>how about responding

Sorry. Jeg synes I begge har været god hjælp. Her er point.

tak :o)