Escape you input strings: insert into foo values ('I haven''t done that');
On 13/12/06, Kirrthana M <[EMAIL PROTECTED]> wrote:
Hi,
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....
Thanks,
Kirrthana
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
