...

View Full Version : replace quotation marks



esthera
04-04-2006, 09:00 AM
I am trying to replace all " to a ' so I can put an sql into a form.
my current code is
sql=replace(sql,""","'") but this is not working.
What am I doing wrong?

degsy
04-04-2006, 03:06 PM
Use an editor with Syntax Highlighting so you know when your strings are correct.



<%
sql = "Hello ""World"""
Response.Write sql
Response.Write "<br>"

sql=replace(sql,"""","'")
Response.Write sql
%>



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum