Escape you input strings: insert into foo values ('I haven''t done that');

On 13/12/06, Kirrthana M <[EMAIL PROTECTED]> wrote:

In my query for inserting values into the database i have a statement as
given below
insert into table_name values('I haven't done that');

table is created with this option
create table table_name(str varchar(20));

when the insert statement is executed it gives the error in haven't,It is
working fine if i remove the apostrophe,
but my input string will contain the apostrophe..
Give me a suggestion for rectifying this....


To unsubscribe, send email to [EMAIL PROTECTED]

Reply via email to