Re: replacing the tic with a double tic in embedded SQL statements

2000-08-22 Thread Shibi Sudhakaran
Use PreparedStatement to Insert the values. It will allow tic also. shibi Enter your default signature here Sent by Indya Messaging Service === To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". Som

Re: replacing the tic with a double tic in embedded SQL statements

2000-08-19 Thread Neal Cabage
. Ottinger Sent: Saturday, August 19, 2000 3:53 AM To: [EMAIL PROTECTED] Subject: Re: [JSP-INTEREST] replacing the tic with a double tic in embedded SQL statements Sure, use PreparedStatements instead of executeQuery. ps.setString(1, "This ain't wrong"); will handle escaping properly.

Re: replacing the tic with a double tic in embedded SQL statements

2000-08-19 Thread Joseph B. Ottinger
Sure, use PreparedStatements instead of executeQuery. ps.setString(1, "This ain't wrong"); will handle escaping properly. On Sat, 19 Aug 2000, Neal Cabage wrote: > I am building a dB interface where people will enter free-form information, > and would like to facilitate the the possiblity that

Re: replacing the tic with a double tic in embedded SQL statements

2000-08-19 Thread Nath Niraj
Hi, Even I don't know if there is any such method but u can design one such simple method for this purpose regards Niraj === To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". Some relevant F

replacing the tic with a double tic in embedded SQL statements

2000-08-19 Thread Neal Cabage
I am building a dB interface where people will enter free-form information, and would like to facilitate the the possiblity that someone might enter an apostrophe. Since a apostrophe (') is used to enclose string values within an SQL statement, when building SQL statements within JSP, it will be