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 |
|
notsosuper
Posting Yak Master
190 Posts |
 Posted - 2005-05-26 : 11:22:27
|
| Here the code firsttc = New TableCell tc.Text &= "[<a href=""business.aspx?id=" & rs.Item("businessname") & "&action=e"" class=""minilink"">edit</a>]"when I am getting record from sql database if the record has & character it is not recognizing and stops right there. For example, if the rs.item("businessname") happen to be A & B , it gets only A and stops there and doesn't get the whole thing. Why this is happening? |
|
|
twhelan1
Yak Posting Veteran
71 Posts |
Posted - 2005-05-26 : 15:44:21
|
| If the business name has an & in it, it's seen as two different query string parameters because query strings are delimited by &. To use an "&" in a URL you have to replace the "&" character with the escape code "%26".This link has a more in-depth explanation:http://www.biglist.com/lists/xsl-list/archives/200104/msg01061.htmlHope that helps. |
 |
|
|
|
|
|
not reading character