You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@beehive.apache.org by Hoi Lam <hl...@bea.com> on 2004/11/05 02:18:30 UTC

RE: DataBase Controls - special characters

Hi Bala, 

Sorry for the late response (I was away for a few days).  The Database
Control does handle single quotes, and you do not need to escape them.  

Hoi

-----Original Message-----
From: Bala Sankar [mailto:bsankar@polivec.com] 
Sent: Sunday, October 31, 2004 10:42 AM
To: Beehive Developers
Subject: DataBase Controls - special characters

The application developers shall use the Database Controls, by coding
the SQL Statements.

Assume that the SQL statement has special characters like single quote.

For instance, 
 SELECT price from ProductTable where item=Levi's Jeans Pants

Does the application developers need to escape the single quote? Can the
Database controls handle this job ?

Thanks
Bala.