Content-Type: text/plain; charset="iso-8859-1"
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
From: "Josh Williams" <drykath@runbox.com>
To: shavonne.marietta@studioform.it
CC: pgsql-sql@postgresql.org
Subject: Re: INSERT INTO
Date: Fri, 16 Mar 2007 20:19:53 -0500 (EST)
References: <002c01c767a8$20d5d600$1102a8c0@dream>
In-Reply-To: <002c01c767a8$20d5d600$1102a8c0@dream>
Message-Id: <E1HSNaL-0003K5-8U@fenris.runbox.com>

From: "Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>
> 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..

I'm sadly tasked with maintaining a little ASP code from time to time.  If =
you need to do it through a script, what you're looking for is the Replace =
function, as already mentioned in the thread:

Replace( InputString, "'", "''" )

However since we're already on pgsql-sql, assuming you're not doing a whole=
 lot more than pulling from one table and inserting into another, you may w=
ant to consider seeing if you can roll it into a single SQL statement:

> INSERT INTO TABLE2 (TE_INDI) VALUES ('SANT'ANGELO LODIGIANO');

INSERT INTO TABLE2 (TE_INDI) VALUES SELECT TE_INDI FROM TABLE1 WHERE (...)

No quoting or server->client->server worries to deal with at all...

Best of luck,
 - Josh Williams