To add a little to this situation...
This will fix the "double-quotes" situation, but will cause the same problem on single-quotes now, a problem I had dealing with both in the data. To get data containing both I used the Replace command and substituted the ascii code equivalent. For example Replace(string,"'","#039;"). This will replace all single-quotes with the ascii code and the browser will not interpret it as a delimiter of the field. Combined with the above solution, this allows one to display both in the resulting HTML output.
|