SQL Server Memo insert

[Gregory Price]

Hello, I am running Jrun and have run into a problem submitting a long string.

The long string a user submits will likely be in French,
which means a lot of single and double quotes.  I am
now able to submit this field under normal circumstance, but my code is
choking on these characters...  I bet you guys can nail this one pretty
quick...  I must need a function when I set that large string as a
variable... Your help is very much appreciated.  code is below:

<%@ taglib uri="jruntags" prefix="jrun" %>

<% String news_ID= request.getParameter("news_ID"); %>
<% String newsletter_ID= request.getParameter("newsletter_ID"); %>
<% String heading= request.getParameter("heading"); %>
<% String entry= request.getParameter("entry"); %>
<% String enteredby=request.getParameter("enteredby"); %>
<% String newslettermonth= request.getParameter("newslettermonth"); %>
<% String newsletteryear= request.getParameter("newsletteryear");
 String sqlQuery = "INSERT INTO news (newsletter_ID,  heading, entry,
enteredby)   VALUES ("
 +newsletter_ID + ", '"
 +heading+ "', '"
 +entry+"', '"
 +enteredby+"')"; %>



<%--INSERT NEWSITEM--%>
   <jrun:sql datasrc="afdallas" id="allnews">
    <%=sqlQuery%>
   </jrun:sql>

 

 

Thanks

Greg Price