Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Translate MS ticks and quotes

Status
Not open for further replies.

kensington43

Technical User
Nov 29, 2005
50
US
I have Access 2000 as a Back end to my Cold Fusion Front end web application. Whenever users copy and paste Microsoft Word data that has quotes and ticks into the Cold Fusion web page, the ticks and quotes show up as squares in my database as if it doesnt translate correctly.

I know that:
The ascii value for a ' is 39
The ascii value for a " is 34

Now how do I translate this each time a record is inserted or updated in the databas and the user enters a quote or tick?

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top