Jack Michaelson — Thu, 20 Jan 2000 07:40:00 +0000

I think I'll go for Eugene's solution. In fact, I'm using the HTMLEncode on other pages. So why it didn't came up to me to use it here also will always be a mystery I think Thanks anyway RC & Eugene.

Jack.

Eugene Grinberg — Mon, 17 Jan 2000 23:58:00 +0000

The best thing to do is to convert everything to HTML format by using Server.HTMLEncode. This will convert all " to " and you won't have any problems.

do something like this:
Response.Write(Server.HTMLEncode(varRecordSet("DB_Field")))

Eugene

[This message has been edited by Eugene Grinberg (edited 17 January 2000).]

RC — Mon, 17 Jan 2000 13:35:00 +0000

I THINK that this can be accomplished using the VBScript replace function. Here is the code that replaces single quotes with double quotes from a feedback form. You should be able to alter it to fit your needs.

strCompanyName = Replace(Request.form("NAME"), "'", "''")

or if not, maybe you can look into the replace function and figure something out.