Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
acdacd
Yak Posting Veteran
63 Posts |
 Posted - 2005-11-13 : 10:45:17
|
Best way to store text in SQL Server for ASP pagesRefer to: [url]http://www.sqlteam.com/item.asp?ItemID=202[/url] quote:
Quotes and QueriesYou'll also spend time getting quotes handled properly. SQL Server needs single quotes converted to two single quotes. IIS 5.0 needs double quotes converted to something else to pass the string through POST. I convert them to a weird string, pass them and then convert them back
My question:I do not understand this passwage so well. Can any one give me some example? I know that i can deal ['] with replace function to [''] or something like that. But I dont understand the IIS part, what is weird string?Actually, i am curently using sql 2000 and MS asp.net with VS 2003. Any difference need to be cared since i will have similiar requirement with the question of the referred article?(Eg. I have 500 articles, ranging in size from 500 characters to 25,000 characters. )Thx in advanced!be a hardworking people!! |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-11-13 : 11:48:17
|
he meant replacing " to _xx_xx_ and then back to "where _xx_xx_ is the weird string that never occurs in normal text._xx_xx_ can be whatever you want.Go with the flow & have fun! Else fight the flow  |
 |
|
|
|
|
|
store text in SQL Server for ASP.net page