Some of my values coming back in my recordset have a ' in them. This data is being read into a JS array so I need to change the ' in the result to the ' html hex code.
MaddTechwf 0 Junior Poster in Training
JorgeM 958 Problem Solver Team Colleague Featured Poster
Ok, so sounds you need to HTML encode the string in the record set...
Try using Server.HTMLEncode(yourString)
Not sure if this will work for the apostrophe.
If that doesnt work for you, I would try using the Replace method:
variableName = Replace(variableName, "'", "'")
MaddTechwf 0 Junior Poster in Training
I found the REPLACE function after I asked this question. Sorry, got it working now.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.