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
