|
have u checked the variable names u are declaring
Connection as con whereas using it as c
----- Original Message -----
Sent: Friday, August 31, 2001 12:50
AM
Subject: Re: SQL Server Memo insert
This issue I posted about 10 days ago, and havent
had a chance to jump back on this project until now... Still having
trouble, I appreciate all your help... I am trying out a prepared
statement now, but I am stuck. According to the advice on this wonderful
list, this prepared statement should work for me. Problem is... I am not
familiar with the concept of a prepared statement... this is what
I've got:
<%
Connection c =
null;
// Do the connection code
first
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String
url="jdbc:odbc:afdallas";
Connection
con=DriverManager.getConnection(url, "username",
"password");
try
{
PreparedStatement pstmt =
c.prepareStatement("INSERT INTO news (newsletter_ID, heading, entry,
enteredby) VALUES (?, ?, ?, ?)
");
pstmt.setInt(1,Integer.parseInt(request.getParameter("newsletter_ID").trim())
);
pstmt.setString(2,
request.getParameter("heading").trim()
);
pstmt.setString(3,
request.getParameter("entry").trim()
);
pstmt.setString(4,
request.getParameter("enteredby").trim()
);
pstmt.executeUpdate();
} catch(Exception exc)
{
}
%>
Could the problem be that I am not releasing the
connection... and if so... How do I release the connection? This code
doesnt error out, it just doesnt do the insert!
Using SQL Server, Jrun, Windows...
Thanks for all your help
Greg Price
----- Original Message -----
Sent: Monday, August 20, 2001 12:00
PM
Subject: Re: SQL Server Memo
insert
Use a prepared statement -- it'll take
care of all those details for you -- I don't know how the tablib you're
using will support it but that's the easiest and correct way to
go.
Clayton
----- Original Message -----
Sent: Monday, August 20, 2001 4:54
PM
Subject: Re: SQL Server Memo
insert
Nope, thanks for your response, but that
doesnt work either! Let me know if anyone has any ideas.
Thanks
Greg
----- Original Message -----
Sent: Monday, August 20, 2001 10:45
AM
Subject: Re: SQL Server Memo
insert
Hi Gregory,
I think you need to replace the '
(apostrophe) character with a '' (double
apostrophe) before you
insert the string into your db
and it should work
fine.
Jon
-----Original Message-----
From: Gregory
Price [mailto:[EMAIL PROTECTED]]
Sent: 20 August 2001 16:26
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
----------------------DISCLAIMER-----------------------
The
information contained in this e-mail and any files
transmitted with
it are confidential and intended for
the addressee only. No other
person is authorised to
copy, forward, disclose, distribute or retain
this
email in any form. If you have received this e-mail in
error
please notify the originator or send an e-mail
to
[EMAIL PROTECTED] This e-mail and any
associated
attachments have been scanned for viruses
prior to dispatch, however
Emap Performance and its
subsidiary companies accept no liability for
any losses
resulting from infected e-mail
transmissions.
Please note any views expressed may be those of
the
originator and do not necessarily reflect those of
this
organisation.
--------------------------------------------------------
Hi Gregory,
I think you need to replace the ' (apostrophe) character with a
'' (double apostrophe) before you insert the string into your db
and it should work fine.
Jon
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
|
