Hi,
If you are using JTurbo try adding sql70=true at the end of the connection
string. By default
it restricts the number of characters to 255.
regards,
Nagarajan.
-----Original Message-----
From: A mailing list about Java Server Pages specification and reference
[mailto:[EMAIL PROTECTED]]On Behalf Of Gregory Price
Sent: Monday, August 20, 2001 5:26 PM
To: [EMAIL PROTECTED]
Subject: SQL Server Memo insert
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
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
