Hi all friends,
Why do I get only one record return with these "Like" clause? I know I have more than one record of that one author or body. In fact, the query pulls only the most recent one.
Can anyone shed some light on this behavior?
Thanks much! -Tivoli0
Why do I get only one record return with these "Like" clause? I know I have more than one record of that one author or body. In fact, the query pulls only the most recent one.
Code:
<%
if request.form("keywordBody") <> "" then
SQL = "SELECT * FROM articles WHERE body LIKE '%" & Request.Form("keywordBody") & "%'"
else
SQL = "SELECT * FROM articles WHERE author LIKE '%" & Request.Form("keywordAuthor") & "%'"
end if
%>
Can anyone shed some light on this behavior?
Thanks much! -Tivoli0