|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
Ajax Application Generator Generate database and reporting .NET Web apps in minutes. Quickly create visually stunning, feature-rich apps that are easy to customize and ready to deploy. Download Now!
|
|
#1
September 9th, 2003, 01:21 AM
|
|||
|
|||
SQL converts ' to " in content output
Hi
I am trying to find the easiest way to make sure that all reserved chars are output correctly when rendering content to the web. Characters like ' and bullets etc. are either changed or removed completely. e.g content is entered as "the boy's bicycle" and outputed as "the boy"s bicycle" Please help Thank
|
|
#2
September 9th, 2003, 07:30 AM
|
||||
|
||||
|
If you are using ASP, you can always use the replace function. or you can just use a ' for the tags instead of a "
e.g. input type='text' value='%oRS("whatever")%' Otherwise you can replace the stuff when you select them from sequal e.g. Code:
select replace(surname,'''' ,'"') from member
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > SQL converts ' to " in content output |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
 |
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
