Replace Single Quotes On Insert & Update
SQL generates an error when it runs into a single quote. I could really use a turorial on how to easily replace a single quote with two single quotes when updating and inserting a page. I have seen enough articles for asp gurus on how to do it. None, however for us dreamweaver mx dependent guys out there. Make it easier to understand for me.
How do I impliment this code, where in a dreamwever mx generated insert function does it go and do i rename anything?
<%
strSQLQuery = Replace(strSQLQuery, "'", "''", 1, -1, 1)
%>
Thanks,
Joe
Comments
Be the first to write a comment
You must me logged in to write a comment.