View Single Post
  #7 (permalink)  
Old March 1st, 2006, 06:21 PM
ChrisScott ChrisScott is offline
Friend of Wrox
 
Join Date: Jul 2003
Location: , , United Kingdom.
Posts: 683
Thanks: 0
Thanked 1 Time in 1 Post
Default

You just need to replace apostrophes with two apostrophes e.g.
Code:
choice = request("choice")
If choice <> "" Then
    choice = Replace(choice, "'", "''")
End If
HTH,

Chris

Reply With Quote