= 2007-03-16 9:50 >>> Hello =20 I have 2 tables. TABLE1 and TABLE2. =20 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) =20 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 =20 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.. =20 INSERT INTO TABLE2 (TE_INDI) VALUES ('SANT'ANGELO LODIGIANO'); =20 Thanks =20 Shavonne Wijesinghe http://www.studioform.it ( http://www.studioform.it/ ) =20 =20 --=__PartC9ED7B43.0__= Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Description: HTML

I don't use ASP but in PHP I would do something in the line of

$valuetoinsert =3D "SANT'ANGELO LODIGIANO";

$query =3D "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.<= /DIV>

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

--=__PartC9ED7B43.0__=--