Sætter jeg parenterserne rigtigt i min søge streng?
Hejsa...Sætter jeg parenterserne rigtigt i min søge streng?
sql:
-------------------------
"SELECT PostID, ForumID, Subject, Post, Publisher, PostDate " & _
"FROM tblForums_Customers_Posts " & _
"WHERE (Subject LIKE '%" & Library.Format.CleanUpInput(searchString).ToString & "%' " & _
"AND Post LIKE '%" & Library.Format.CleanUpInput(searchString).ToString & "%' " & _
"AND Publisher LIKE '%" & Library.Format.CleanUpInput(searchString).ToString & "%' " & _
"AND PostDate LIKE '%" & Library.Format.CleanUpInput(searchString).ToString & "%') " & _
"AND ForumID=@ForumID " & _
"ORDER BY PostDate DESC;"
Min søgning virker, men den viser langt fra alt!
:-(
Mvh
DN