how to handle single quotation marks

[new]

Just wonder how you guys handle the single quatation marks when you
write the value of a text input into SQL server. Thanks!

* * * Sent via DevBuilder http://www.devbuilder.org * * *
Developer Resources for High End Developers.

 

[Aaron Bertrand - MVP]

Double them up.
www.aspfaq.com/2035

 

[solex]

I wrote a replaceall function to handle this problem and create a DLL with
common string functions:

Function ReplaceAll(ByVal Buffer As String, ByVal FindWhat As String, _
ByVal ReplaceWith As String) As Variant
'
' Replaces all instances of FindWhat with ReplaceWith in the
' buffer
'
Dim intLenFind As Integer
Dim intLenReplace As Integer
Dim intPos As Integer

If Len(Buffer) = 0 Then
ReplaceAll = ""
Else
intLenFind = Len(FindWhat)
intLenReplace = Len(ReplaceWith)

intPos = 1
Do
intPos = InStr(intPos, Buffer, FindWhat)
If intPos > 0 Then
Buffer = Left(Buffer, intPos - 1) & _
ReplaceWith & Mid(Buffer, intPos + intLenFind)
intPos = intPos + intLenReplace
End If
Loop Until intPos = 0
End If

ReplaceAll = Buffer

End Function

 

[new]

Thank you!

I was doing a similar thing, by replacing ' to something like @#$%

* * * Sent via DevBuilder http://www.devbuilder.org * * *
Developer Resources for High End Developers.

 

[Aaron Bertrand - MVP]

I was doing a similar thing, by replacing ' to something like @#$%

And then switching it back again, in every single application that connects
to that table? Ick...