Hi.
I got a database like this
Title | Language
Test1 en
Test2 en
Test3 se
and I want so search on the Title and with a language. Sometimes "en" and "se" and sometime just one language. I created this query but I can't make it work with the "language" selection. Any idéa how to combine several boolean expressions??
Tnx!Code:SQL = "SELECT * From Stories" SQL = SQL & " WHERE Titel LIKE '%" & Request.Form("titel") & "%'" If Request.Form("swedish") <> "ON" Then SQL = SQL & " AND Language = 'se'" If Request.Form("english") <> "ON" Then SQL = SQL & " AND Language = 'en'"




Reply With Quote