From: Bart Degryse <Bart.Degryse@indicator.be>
To: pgsql-sql@postgresql.org
Cc: Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
Subject: Re: INSERT INTO
Date: Fri, 16 Mar 2007 10:03:15 +0100
Message-ID: <45FA6B62.A3DD.0030.0@indicator.be> (raw)
In-Reply-To: <002c01c767a8$20d5d600$1102a8c0@dream>
References: <002c01c767a8$20d5d600$1102a8c0@dream>
I don't use ASP but in PHP I would do something in the line of
$valuetoinsert = "SANT'ANGELO LODIGIANO";
$query = "INSERT INTO TABLE2 (TE_INDI) VALUES ('" . str_replace("'", "''", $valuetoinsert) . "')";
I'm sure ASP has also a string replacement function
>>> "Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it> 2007-03-16 9:50 >>>
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 ( http://www.studioform.it/ )
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Bart.Degryse@indicator.be, shavonne.marietta@studioform.it
Subject: Re: INSERT INTO
In-Reply-To: <45FA6B62.A3DD.0030.0@indicator.be>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox