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

LastName = "O'Leary"
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")) & "')"
My3C's
perrychicker
It's easy... it's a PSACAKE!
Back | Tell A Friend | Search this Site
© 1998 - 2010 psacake.com
Version 3.23

Send me One Million FREE Guaranteed Visitors