Re: SQL update/insert for a string contain " ' " -- JAVA400-L

Or better,
use prepared statements, the problem will disappear.

Ciao.


On Fri, 5 Oct 2001 09:03:49 -0500, Fred Kulack wrote:

>
>On 10/04/2001 at 11:18:54 AM, java400-l-admin@midrange.com wrote:
>I would recommend (for portability) that you also use substitution for the
>key.
>so DESCRIPTION = ? where ID = 1"); becomes
>DESCRIPTION = ? where ID = ?");
>
>--- end of excerpt ---
>
>I agree completely.
>From the original example source, I'd guess that this statement
>could then be used in other places in the app with different
>ID values, reducing the total number of prepared statements
>required.
>
>
>In every single ethnic, religious or racial group, there are a
>very few truly evil people. For each of those people there
>are many, many, many good people.
>Assuming anything (evilness or capability for evil) about the
>particular group is bigotry and idiocy. Don't do it.  -- Me
>
>Fred A. Kulack  -  AS/400e  Java and Java DB2 access, Jdbc, JTA, etc...
>IBM in Rochester, MN  (Phone: 507.253.5982   T/L 553-5982)
>mailto:kulack@us.ibm.com   Personal: mailto:kulack@magnaspeed.net
>AOL Instant Messenger: Home:FKulack  Work:FKulackWrk
>
>_______________________________________________
>This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) 
>mailing list
>To post a message email: JAVA400-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
>or email: JAVA400-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/java400-l.
>
>


<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Author" content="Franco Biaggi">
<meta name="GENERATOR" content="Franco Biaggi">
</head>

<body>

<p>&nbsp; </p>

<table BORDER="1" COLS="1" WIDTH="452" BGCOLOR="#FFFF00">
  <tr>
    <td width="446"><font face="Comic Sans MS"><small><small><br>
    <font color="#3333FF"><a href="http://www.ticino.com/usr/fbiaggi/">Franco 
Biaggi</a></font><small><br>
    <font color="#3333FF"><a href="http://www.sisa.ch">SISA Studio Informatica 
SA</a></font><small><small><small> <br>
    </small></small></small><font color="#3333FF">R&amp;D 
Services</font><small><small><small>
    <br>
    </small></small></small><font color="#3333FF">Via Carvina 
1</font><small><small><small> <br>
    </small></small></small><font color="#3333FF">CH-6807 
Taverne</font><small><small><small> <br>
    </small></small></small><font color="#3333FF">Efax +1 801 705 
2839</font></small></small></small><br>
    </small></small></small><font color="#3333FF">Tel. +41 91 935 75 35&nbsp; 
Fax. +41 91 935
    75 30</font></small></small></small><br>
    </small></small></small><font color="#3333FF">Sorry for my bad 
english...</font><small><small><small> <br>
</font></td>
  </tr>
</table>
</body>
</html>