Still trying to figure this one out...I've tried a number of things, and since my
knowledge base is pretty low... i am out of ideas. Any other suggestions (I apprciate
your help). My error is [Microsoft][ODBC SQL Server Driver][SQL Server]Line 6:
Incorrect syntax near '�tranger'. Due to appostrophies or the character on that "e"
from a long string insert.... code is at the bottom of this email.
Thanks again
Greg Price
----- Original Message -----
From: "Mark Phelps" <[EMAIL PROTECTED]>
To: "JRun-Talk" <[EMAIL PROTECTED]>
Sent: Friday, August 17, 2001 11:02 AM
Subject: RE: Memo Problem Part II
> 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
