|
|
|
|
|
| | |
| |
PowerASP active server pages asp.net microsoft .net framework sdk learn asp what is asp tutorial learn asp.net CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: replace a qoute by two quotes |
|
From: |
Brian |
|
Date: |
12/6/2000 5:42:40 AM |
|
IP: |
203.149.1.60 |
I use the replace function in VBScript on all my strings which could contain a single quote such as OBrien or Joes Truckstop so that the database doesnt think it is the string delimiter. NB:It is important to replace the single quote with two single quotes and not a double quote
Simple Example:
myString = "O'Brien"
myString = Replace(myString,"'","''")
When mySting is sent to the db and you out again it will appear as O'Brien.. amazingly simple
|
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
