DaniWeb Forum Index > Web Development > ASP

Microsoft JET Database Engine (0x80040E14), Please Help.

Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Feb 2008

Posts: 6

Reputation: SBox is an unknown quantity at this point

Solved Threads: 0

SBox

Offline

Newbie Poster

Microsoft JET Database Engine (0x80040E14), Please Help.

Feb 19th, 2008

I Programmed A CMS ( Control Mangament System ) With ASP And When I Programmed The Search Engine This Error Messege Apears :

 Help with Code Tags 
 ASP Syntax (Toggle Plain Text) 
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
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

 Help with Code Tags 
 ASP Syntax (Toggle Plain Text) 
<!--#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">&nbsp;</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" -->
<!--#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">&nbsp;</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

 Help with Code Tags 
 ASP Syntax (Toggle Plain Text) 
<!--#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" -->
<!--#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" -->