|
 |
asp_web_howto thread: Quotes and Apostrophes
Message #1 by "Joe Ehrenfeld" <joee@v...> on Tue, 23 Oct 2001 21:58:03
|
|
How do you fix the problem of inserting quotes and apostrophes into a
database? FYI, I have a comment field in my form and I need to be able to
accomondate quotes and apostrophes.
Thanks
Message #2 by "Daniel O'Dorisio" <daniel@o...> on Tue, 23 Oct 2001 18:45:38 -0400
|
|
Replace a single ' with '' and you will be fine.
daniel
--------------------------
Daniel O'Dorisio
daniel@o...
www.odorisio-networks.com
--------------------------
-----Original Message-----
From: Joe Ehrenfeld [mailto:joee@v...]
Sent: Tuesday, October 23, 2001 9:58 PM
To: ASP Web HowTo
Subject: [asp_web_howto] Quotes and Apostrophes
How do you fix the problem of inserting quotes and apostrophes into a
database? FYI, I have a comment field in my form and I need to be able
to
accomondate quotes and apostrophes.
Thanks
daniel@o...
$subst('Email.Unsub')
Message #3 by "Morgan, Rob" <Rob.Morgan@o...> on Wed, 24 Oct 2001 07:07:22 -0400
|
|
Public function ChkString(fString)
fString = Trim(fString)
fString = Replace(fString, "'", "''")
fString = Replace(fString, CHR(13), " ")
ChkString = fString
end function
-----Original Message-----
From: Joe Ehrenfeld [mailto:joee@v...]
Sent: Tuesday, October 23, 2001 5:58 PM
To: ASP Web HowTo
Subject: [asp_web_howto] Quotes and Apostrophes
How do you fix the problem of inserting quotes and apostrophes into a
database? FYI, I have a comment field in my form and I need to be able to
accomondate quotes and apostrophes.
Thanks
|
|
|
View Cart
