Replace Apostrophes Function

When an apostrophe ( ' ) is inserted into an insert string errors will occur. The following will cause errors:

<%
LastName = "O'Neal"
Conn.Execute "INSERT (LastName) VALUES ('" & LastName & "')"
%>

The following function will solve this problem:

<%
FUNCTION
theFIX( theVariable )
theFIX=Replace(theVariable, "'", "''")

' this replaces a single apostrophe ( ' ) with two single apostrophes ( ''). Note: two single apostrophes, not one quotation mark
END FUNCTION
%>

Now use the function in the string:

<%
Conn.Execute "INSERT .... (LastName) VALUES ('" & theFIX(Request("LastName")) & "')"
%>


replace asp apostrophes formating SQL


Back To Top
© 1998 - 2014 psacake.com | My3C's

Version 7.0a | Advertise on this site