Replace that with double single quotes and try. But not with double quote.
 Tan wrote:i am using jsp to do a search program. i faced problem when i am trying 
to search a word that contains ' for example, when i do search for

book's

it will give me error

/******message*******/
rs java.sql.SQLException: ERROR: parser: parse error at or near "s" 

may i know how to overcome it?


---------------------------------
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes