I Programmed A CMS ( Control Mangament System ) With ASP And When I Programmed The Search Engine This Error Messege Apears :
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression '??????? like '%??? ??????%' or ?????? like '%??? ??????%' or ????? ??????? like '%??? ??????%' or ????? like '%??? ??????%' or ??????? like '%??? ??????%''.
/science/search.results.asp, line 12
The Search.asp Is
<!--#include file="appearances/grey/templates/header.htm" -->
<tr><td colspan="6" bgcolor="#DFDFFF" align="center" width="33%">محرك البحث</td></tr>
<td colspan="6">
<form method="GET" action="search.results.asp">
<p align="center"> </p>
<p align="center">
<input type="text" name="Word" size="20"></p>
<p align="center">
<input name="reset" type="reset" value="اعادة" style="width: 45px; height: 25px">
<input name="submit" type="submit" value="ابحث" style="width: 45px; height: 25px">
</p>
</form>
<hr color="#DFDFFF">
</td>
<!--#include file="appearances/grey/templates/footer.htm" -->
And The Search.Results.asp IS
<!--#include file="appearances/grey/templates/header.htm" -->
<tr>
<td colspan="6">
<!--#include file="connection.asp" -->
<%
Word=request.querystring("Word")
SelectLessonsSQL="select * from الدروس where العنوان like '%"&Word&"%' or الكاتب like '%"&Word&"%' or تاريخ الاضافة like '%"&Word&"%' or الوصف like '%"&Word&"%' or المحتوى like '%"&Word&"%'"
set abedLessons=SB.execute(SelectLessonsSQL)
SelectBooksSQL="select * from الكتب where العنوان like '%"&Word&"%' or الكاتب like '%"&Word&"%' or تاريخ الاضافة like '%"&Word&"%' or الوصف like '%"&Word&"%' or الرابط like '%"&Word&"%'"
set abedBooks=SB.execute(SelectBooksSQL)
do while not abedLessons.eof
%>
<a href="show.lesson.asp?LessonName=<%=abedLessons("العنوان")%>"><%response.write abedLessons("العنوان")%></a>
<%
abedLessons.movenext
loop
do while not abedBooks.eof
%>
<a href="show.all.books.asp?SectionName=<%=abedBooks("القسم")%>"><%response.write abedBooks("العنوان")%></a>
<%
abedBooks.movenext
loop
SB.close
%>
<hr color="#DFDFFF">
</td>
</tr>
<!--#include file="appearances/grey/templates/footer.htm" -->
Please What Is The Error ?