|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Please Help - Microsoft JET Database Engine error '80040e14'
Please can someone help I am new at this, I have a problem with the above error,
I have two files running 1. modifynews.asp - a form to complete 2. modifynewsexec.asp - the exec file that puts the code into a database. If I want to put more than one line of news into the submit throws back: Microsoft JET Database Engine error '80040e14' Syntax error in query. Incomplete query clause. /modifynewsexec.asp, line 16 I have checked thru the code but cant find out why I can enter one line but no more. My Code: modifynewsexec.asp: <!--#include file="includes/dbconnection.asp"--> <% Dim cnnSimple Dim rstSimple Dim strDBPath pmain = request("Mainnews") pdiv1 = request("div1") pdiv2 = request("div2") pdiv3 = request("div3") %> <% ' UPDATE DIVISION DATA SET rstSimple = cnnSimple.Execute ("UPDATE MainNews.* SET Mainnews='"&pmain&"', div1='"&pdiv1&"', div2='"&pdiv2&"', div3='"&pdiv3&"';") %> <% RESPONSE.REDIRECT "adminhome.asp" %> ModifyNews.asp: <!--#include file="includes/dbconnection.asp"--> <!--#include file="navigation.asp"--> <% SET RSTSIMPLE = cnnSimple.Execute ("SELECT MainNews.*, MainNews.Mainnews AS Mainnews, MainNews.div1 As div1, MainNews.div2 As div2, MainNews.div3 As div3 FROM MainNews;") %> <% pmain = rstSimple.Fields("Mainnews").value pdiv1 = rstSimple.Fields("div1").value pdiv2 = rstSimple.Fields("div2").value pdiv3 = rstSimple.Fields("div3").value %> <form action="modifynewsexec.asp"> <font color="#7DACFB"><h3>Main News Update</h3><%pmain%><font size="-3">To Enter a Line Break You Cannot Just Press Enter You Must Type < br ></font></font> <textarea cols="70" rows="5" name="Mainnews" style="background-color: Silver;"></textarea> <font color="#7DACFB"><h3>Division 1 News Update</h3><%pdiv1%></font> <textarea cols="70" rows="3" name="div1" style="background-color: Silver;"></textarea> <font color="#7DACFB"><h3>Division 2 News Update</h3><%pdiv2%></font> <textarea cols="70" rows="3" name="div2" style="background-color: Silver;"></textarea> <font color="#7DACFB"><h3>Division 3 News Update</h3><%pdiv3%></font> <textarea cols="70" rows="3" name="div3" style="background-color: Silver;"></textarea> <br> <input type="submit" name="Submit"> <input type="reset" name="Reset"> </form> The dbconnection.asp file : <% strDBPath = Server.MapPath("database/darts.mdb") Set cnnSimple = Server.CreateObject("ADODB.Connection") cnnSimple.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath & ";" %> I would be greatful for any help. |
![]() |
| Viewing: ASP Free Forums > Other > Programming Help > Please Help - Microsoft JET Database Engine error '80040e14' |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|