Subject: JSP handling of single quote

Google

Mailing List

Home

Forum Home

JBoss - Java Application Server

Tomcat - JSP/Servlet container

Struts - A MVC web framework

iText - An open source PDF Java Library

JDOM - JDOM XML Parser

JSP - A mailing list about Java Server Pages specification and reference

J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition

J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog

Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology

Struts & Hibernate

Subjects

•	JSP editor plugin for eclipse ?
•	org apache jasper JasperException: Unable to compile class for JSP
•	Tomcat: Connection reset by peer: socket write error
•	Cannot retrieve definition for form bean null
•	Struts Tiles Tutorial (free Struts training)
•	Where do I download Tomcat 4 0 6?
•	Data Access Object (DAO) pattern, example DAO 's
•	Where to download Tomcat v 4 1 24 from?
•	Tomcat 5 0 16 Requested resource not available
•	Subject: Servlet : Session invalidate
•	Oracle Connection Pooling in 3 2 2
•	Servlet action is currently unavailable
•	Tomcat/Struts Unicode Encoding/Decoding problems
•	Subject: Running a Simple JMS Example
•	Tomcat and webapplication specific java library path
•	Mapping in workers2 properties
•	org apache jasper JasperException
•	problem with html:text bean throwing exception
•	Cannot find message resources under key org apache struts action MESSAGE
•	Cannot find message resources under key org apache struts action MESSAGE
•	invalid direct reference problem with solution
•	Tool for jsp debug Try Sysdeo Eclipse Plugin
•	Tomcat 5 Cannot load JDBC driver class 'null ' SQL state: null
•	weblogic ejbc
•	java properties file
•	Jboss 3 2 3 Coyote Can 't re
•	Tomcat 5, Apache2 and mod jk2 integration problem
•	JBoss example problem new to J2EE
•	Value attribute of <html:checkbox
•	url string for connecting jboss to oracle
•	javax servlet ServletException: BeanUtils populate
•	5 0 18: Windows XP Pro vs Windows 2000
•	HTTP Status 404 The requested resource is not available

Subject: JSP handling of single quote

Subject: JSP handling of single quote

2004-12-03 - By Lewis, Sam

Back

Reply: 1 2 3 4 5 6

You could:

1) Use a preparedstatement which automatically escapes
characters for you.

or

2) yourStr.replaceAll( "'", "''" )

Not really a patterns question though!

-- --Original Message-- --
From: An interest list for Sun Java Center J2EE Pattern Catalog
[mailto:J2EEPATTERNS-INTEREST@(protected)] On Behalf Of Kokkilah
Suntharraju
Sent: 03 December 2004 13:48
To: J2EEPATTERNS-INTEREST@(protected)
Subject: JSP handling of single quote

Wld like advise here if possible. I'm involved in a jsp project
currently using sqlserver.
Hv encountered difficulties inserting string values with single quotes
into sqlserver.

Example
O'Brien wld only be inserted if it is entered as O''Brien with two
single quotes.

Practically this requires parsing of the string variable example strName
that captures O'Brien to add additional single quote.

Wld you know any good jsp solution to this do, appreciate your advise
and help

Thanks

====================================================================
Companion Site: http://www.corej2eepatterns.com J2EE BluePrints:
http://java.sun.com/blueprints/corej2eepatterns List Archive:
http://archives.java.sun.com/archives/j2eepatterns-interest.html
Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to
listserv@(protected)

====================================================================
Companion Site: http://www.corej2eepatterns.com
J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns
List Archive: http://archives.java.sun.com/archives/j2eepatterns-interest.html
Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to listserv@(protected)

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>

<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 10 (filtered)">

<style>

</style>

</head>

<body bgcolor=white lang=EN-GB link=blue vlink=purple>

<div class=Section1>

You could:

1)          
      
Use a preparedstatement
which automatically escapes characters for you.

or

2)          
      
yourStr.replaceAll(
"'", "''" ) 

Not really a patterns question though!

<div>

 

</div>

-- --Original Message---
-- 
From: An interest list for Sun
Java Center J2EE Pattern Catalog [mailto:J2EEPATTERNS-INTEREST@(protected)] On Behalf Of Kokkilah Suntharraju 
Sent: 03
December 2004 13:48 
To:
J2EEPATTERNS-INTEREST@(protected) 
Subject: JSP handling of single
quote

 

<div>

Wld like  advise here if possible. I'm involved
in a jsp project currently using sqlserver. 
Hv encountered difficulties inserting string values with single quotes into
sqlserver. 

Example  
O'Brien  wld only be inserted if it is entered as O''Brien with two single
quotes. 

Practically this requires parsing of the string
variable example strName that captures O'Brien to add additional single quote.

Wld you know any good jsp solution to this do,
appreciate your advise and help 

Thanks 

</div>

</div>

</body>

</html>
====================================================================
Companion Site: http://www.corej2eepatterns.com
J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns
List Archive: http://archives.java.sun.com/archives/j2eepatterns-interest.html
Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to listserv@(protected)
====================================================================
Companion Site: http://www.corej2eepatterns.com
J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns
List Archive: http://archives.java.sun.com/archives/j2eepatterns-interest.html
Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to listserv@(protected)