Snappy2873
Programmer
Good morning,
I currently have a form with fields that posts data to a SQL DB. It works great but bombs on a tic mark (" ' "). I created the following function(in asp include file..) to filter the fields but I cant seem to get it to work:
function FilterQuotes(strSQL)
if not isnull(strSQL) then
if len(trim(strSQL)) then
strInput = Replace(strSQL,"'","")
strInput = Replace(strSQL,"""","")
strInput = Replace(strSQL,"*","")
end if
end if
FilterQuotes = strSQL
end function
Any recommendations would be greatly appreciated.
Thanks in advance,
Snappy
I currently have a form with fields that posts data to a SQL DB. It works great but bombs on a tic mark (" ' "). I created the following function(in asp include file..) to filter the fields but I cant seem to get it to work:
function FilterQuotes(strSQL)
if not isnull(strSQL) then
if len(trim(strSQL)) then
strInput = Replace(strSQL,"'","")
strInput = Replace(strSQL,"""","")
strInput = Replace(strSQL,"*","")
end if
end if
FilterQuotes = strSQL
end function
Any recommendations would be greatly appreciated.
Thanks in advance,
Snappy