error handling routine

[spacehawk]

When users enter text with , or ' in a form they get an error message and the database does not update.&nbsp;&nbsp;Can I write a simple error handling routine that looks for the characters that are not allowed and replaces them with characters that will work?<br><br>Could anyone get me started on this?<br><br>Thanks.

 

[jfriestman]

This'll do the trick.<br><br>Function PrepForSQL(strDirty)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dim strClean<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;If IsNull(strDirty) OR Trim(strDirty) = &quot;&quot; Then<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PrepForSQL = &quot;&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Exit Function<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;End If<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;strClean = Trim(strDirty)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Replace all single quotes with 2 single quotes<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;strClean = Replace(strClean, Chr(39), Chr(39) & Chr(39), 1, -1, 1)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PrepForSQL = strClean<br>End Function <p> Jeff Friestman<br><a href=mailto: > </a><br><a href=

http://www.brainbench.com/transcript.jsp?pid=61192>

View my Brainbench transcript</a><br>Brainbench 'Most Valuable Professional' for ASP<br>

http://www.brainbench.com

 

[JoernSaischek]

use regular expressions. can be used with VBscript, Jscript,Javascript.<br><br>for a start :<A HREF="

http://www.siteexperts.com/paradise/getResource.asp?r_id=1592"

TARGET="_new">

http://www.siteexperts.com/paradise/getResource.asp?r_id=1592</A><br><br>there

are also a lot of articles at <A HREF="

http://www.4guysfromrolla.com"

TARGET="_new">

http://www.4guysfromrolla.com</A><br><br><br><br>