I’m creating a from that allows users to enter in answers to questions. It will be common for them to use apostrophes in their answers, like “I’m planning to attend University next year”. Those apostrophes are causing havoc as ASP is treating them like pieces of the code; I’m looking for a way to automatically change all ‘s into #8217;.

I tried using Server.HTMLEncode(FromElementName) but this didn’t do it. It worked for &s, turning them into &.

In desperation I also tried Server.URLEncode(FromElementName). This also didn’t work.


Any ideas how I can do this?

.m

Hi m,
Will do what you want, but, how is this causing problems in your code - if it's with dynamic query building, IMHO you're better of replacing the apostrophes by doubling them up before adding them to your queries...

That way data stored in a database remains as it was initially submitted & you can query / export it etc without having to worry about reverting any changes you made.

HTH,

Chris

Bigmish,

Also, forget not the quote in red. _________________________
- Vijay G
Strive for Perfection

Thanks Vijay,

Have ammended the posting.

Chris

Thanks Gents, worked like a charm. Hadn’t known about that function. It’s a handy one.

Best, M