Postgres Pro
Downloads
Home   >   mailing lists

INSERT INTO - Mailing list pgsql-sql

From Shavonne Marietta Wijesinghe
Subject INSERT INTO
Date
Msg-id 002c01c767a8$20d5d600$1102a8c0@dream
Whole thread Raw
Responses Re: INSERT INTO
Re: INSERT INTO
Re: INSERT INTO
List pgsql-sql
Tree view
Hello
 
I have 2 tables. TABLE1 and TABLE2.
 
TABLE1 has about 400 records with details (client code, name, surname, address, date of birth) of my clients.
TABLE2 is filled with some of the client details and other extra details (client code, address, telephone, etc)
 
So in my ASP page i have a select that gets the client details from TABLE1 using the client code and inserts them in to TABLE2
 
When i have a string that has a ' inside of it the record is not inserted in to TABLE2. I know that writing it twice will fix it but how can i ask my ASP code to do it..
 
INSERT INTO TABLE2 (TE_INDI) VALUES ('SANT'ANGELO LODIGIANO');
 
Thanks
 
Shavonne Wijesinghe
http://www.studioform.it
 
 

pgsql-sql by date:

Previous
From: T E Schmitz
Date:
Subject: Re: join table with itself?
Next
From: "Bart Degryse"
Date:
Subject: Re: INSERT INTO