|
|
|
|
|
| | |
| |
Active Server Pages help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: SQL Single Quote problem |
|
From: |
Paul Simpson |
|
Date: |
4/5/1999 11:26:15 AM |
|
IP: |
207.207.47.5 |
Sub procFindApostrophe(strTextToFind As String, strFirstOrNext As String)
Dim strSearchQueryString
'Look for apostrophes and replace with 2 apostrophes (or spaces, if you prefer)
'in the query string. This avoids an error that would kick you out of the program.
If InStr(1, strTextToFind, "'", 0) Then strTextToFind = Replace(strTextToFind, " ' ", " ' ' ")
End Sub |
Previous Message
Follow Up - Awsome Works with Access too! - thayne 9/11/1999 5:29:05 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
