data with quotes wrecks html/ap table 2

[sweetleaf]

Hi,
I have an asp which reads data from a database and writes the rows out to a table. some of the database data contains quotes.
it seems that: response.write rs("myfield&quot doesn't understand or know how to process quotes b/c when quoted data is encountered the table borders go all over the place.
Can anyone help please..

thanks

 

[SrikanthMc]

use response.write ( server.htmlencode(rs("myfield&quot) ) and give a try

 

[sweetleaf]

thanks SrikanthMc!

only thing is now i'm getting "type mismatch htmlencode was not handled" messages - why would that be?

 

[hblackorby]

Make sure that you're trying to html encode a string, not say a date/time field. Harold Blackorby
hblackorby@scoreinteractive.com
St. Louis, MO

 

[Rydel]

What a great help! I was usually writing my own functions to replace spaces with " " and quotes with """. And I didn't get any error messages.
---

http://www.geocities.com/rydel23/

---

 

[sweetleaf]

the html table is still going haywire when a quoted piece of data is encountered..

 

[Rydel]

in my previous sample there are two special symbols missing:
& nbsp ;
& quot ;
(because they get automatically processed by the browser)
---

http://www.geocities.com/rydel23/

---

 

[hblackorby]

Try looking at your HTML code output to see what the problem it. It sounds like it might not be the ASP code that is messing it up. Normally a quote in HTML doesn't cause much problems, especially if it is in a table cell. I'd not look at the ASP code, but look at the HTML code from your browser to see if it gives you a clue what's happening. Harold Blackorby
hblackorby@scoreinteractive.com
St. Louis, MO

 

[sweetleaf]

thanks guys youv'e been a great help!