Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    12

    Unanswered: formulation quotation mark in String

    Hi,
    I would like to form contains inquiry (phrase search) in MS SQL Server fulltext. But there are Probleme in the formulation string with the quotation mark " " and ' '. How may I formulate that ('"Dresdner Bank"') correct in java?

    ResultSet rs = wstmt.executeQuery("SELECT titel, author, datum, text_typ FROM texttable_intern WHERE CONTAINS (content, ' "Dresdner Bank" ')");

    "Dresdner Bank" ist the search phrase.


    Thank you


    Diwen

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    try
    ResultSet rs = wstmt.executeQuery("SELECT titel, author, datum, text_typ FROM texttable_intern WHERE CONTAINS (content, ' ""Dresdner Bank"" ')");

Posting Permissions

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