|
 |
access_asp thread: How can insert a string with double quote in it into the database??
Message #1 by "Kenneth Chao" <kenchao828@h...> on Sun, 9 Mar 2003 01:39:53
|
|
Currently, I have difficulty to insert a string into the database when
there are double quotes (") in that string. The problems happened when I
concatenation that string with the SQL statment. The statement will be
ended when the first double quote encurred. Please help me to find out
the solutions, thanks.
Kenneth
Message #2 by "Zee Computer Consulting" <zee@t...> on Sat, 8 Mar 2003 18:45:17 -0800
|
|
Please post your program code.
----- Original Message -----
From: "Kenneth Chao" <kenchao828@h...>
To: "Access ASP" <access_asp@p...>
Sent: Sunday, March 09, 2003 1:39 AM
Subject: [access_asp] How can insert a string with double quote in it into
the database??
> Currently, I have difficulty to insert a string into the database when
> there are double quotes (") in that string. The problems happened when I
> concatenation that string with the SQL statment. The statement will be
> ended when the first double quote encurred. Please help me to find out
> the solutions, thanks.
>
> Kenneth
>
Message #3 by "Ken Schaefer" <ken@a...> on Mon, 10 Mar 2003 13:26:05 +1100
|
|
<%
strMyString = "Here is my string "" with a double quote in it"
strSQL = _
"INSERT INTO myTable (myField) VALUES ('" & strMyString & "')"
%>
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Kenneth Chao" <kenchao828@h...>
Subject: [access_asp] How can insert a string with double quote in it into
the database??
: Currently, I have difficulty to insert a string into the database when
: there are double quotes (") in that string. The problems happened when I
: concatenation that string with the SQL statment. The statement will be
: ended when the first double quote encurred. Please help me to find out
: the solutions, thanks.
:
: Kenneth
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
|
|
View Cart
