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? I think, this ist the java problem.

    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
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: formulation quotation mark in String

    Originally posted by Diwen
    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? I think, this ist the java problem.

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

    "Dresdner Bank" ist the search phrase.
    ResultSet rs = wstmt.executeQuery("SELECT titel, author, datum, text_typ FROM texttable_intern WHERE CONTAINS (content, ' \"Dresdner Bank\" ')");
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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