hey guy another question:

I have a text field on my web page. The problem is that when i type a single quote(') it recoginzies it as the end of the string and i get an error message that i didnt properly end my sql statement. However if i take it out it works like a charm. What do people do in a situation like this, would i have to write a function to strip those out, the problem with that is that im afraid i will lose the formating when the user brings up the text field again. I have to maintain formating. Any suggestion would be greatly appreciated.

regards,

Scott