There may be some database method for dealing with this, but if not, you
might try URLEncoding the French text and then undoing it when you bring it
out of the field later on. URLEncoding will replace international
characters and punctuation with standard character codes.
-----Original Message-----
From: Gregory Price [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 17, 2001 9:27 AM
To: JRun-Talk
Subject: Memo Problem Part II
I really appreciate your input and assembling the SQL as a variable worked
for me. However, one minor detail I neglected (cause I didnt think it would
be an issue) . The long string a user submits will likely be in French,
which means a lot of single and double quotes and strange characters. 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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
