Results 1 to 6 of 6

Thread: SQL Select string where search criteria contains a ' character? [RESOLVED FISH]

Threaded View

  1. Oct 23rd, 2003, 07:35 AM #1
    Wokawidget
    Wokawidget is offline

    Thread Starter
    Super Moderator Wokawidget's Avatar
    Join Date
    Nov 2001
    Location
    Headingly Occupation: Classified
    Posts
    9,632

    SQL Select string where search criteria contains a ' character? [RESOLVED FISH]

    I have a surname in my DB, which is:

    O'Keafe

    But if I build a search SQL string like:
    Code:
    SELECT * FROM tblUsers Where Surname = 'O'Keafe'
    then this gives an error

    Any ideas?

    Woka
    Last edited by Wokawidget; Oct 23rd, 2003 at 07:43 AM.
    My .NET Tutorials:
    • Silverlight Enabled WebPart in WSS

    My VB.NET Code Examples:
    • Create IIS Virtual Directory • Validate Login Against Active Directory • Automatically retrieve Identity field value from inserted DataRow using SQL Server and ADO.NET

    My ASP.NET Code Examples:
    • Login To Website (Forms Authentication) • Login To Website (Custom Authentication)

    My VB6 Code Projects:
    • Multithreading In VB6 • Custom Tooltips • Multi Language Support • Item Selector Control • Annimated Systray Icon • Simple Effective Graph Control • Download From Web • LiveUpdate, download application updates from the web automatically • Systray Notification Messages • Skin A Form • API Timer • Badger Messenger, an MSN clone that uses the MSN Network • Wokawidgets VB6 Component Suite
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width