Results 1 to 2 of 2
  1. #1
    bachtoutou is offline Member
    Join Date
    May 2008
    Posts
    11
    Rep Power
    0

    Default make apostrophe differable in an sql request

    hi evrybody,
    I want to execute an sql request in java.the probleme is that the text i want to insert contains apostrophs.
    Are there any solution to make this apostrophs differable.
    Java Code:
    insert into declencheur values('POST-QUERY','DÉTAILS_ARTICLES','D:\projet2\DÉTAILS_ARTICLES.fmb',[B]
    'if:parameter.P_ART is not null then:ARTICLE.NUM_ART:=:parameter.P_ART;else call_form('D:\projet2\DÉTAILS_ARTICLES');end if;'[/B])
    )

  2. #2
    Eku
    Eku is offline Senior Member
    Join Date
    May 2008
    Location
    Makati, Philippines
    Posts
    234
    Rep Power
    7

    Default

    you can try using the '\'

    example if you use \' the java compiler will look to it as a normalized '. You can also use \\ for normalized \ and \" for " as a normal text.
    Mind only knows what lies near the heart, it alone sees the depth of the soul.

Similar Threads

  1. [SOLVED] http request
    By Eranga in forum Advanced Java
    Replies: 30
    Last Post: 11-27-2008, 04:35 AM
  2. Session and request in JSF
    By felixtfelix in forum Web Frameworks
    Replies: 0
    Last Post: 05-08-2008, 05:10 PM
  3. respose with out request
    By karthikiniyan in forum Java Servlet
    Replies: 1
    Last Post: 04-09-2008, 03:06 PM
  4. How to use request Scope in Spring
    By Java Tip in forum Java Tip
    Replies: 0
    Last Post: 03-31-2008, 10:06 AM
  5. Help with request.getParameter()
    By Albert in forum Enterprise JavaBeans (EJB)
    Replies: 1
    Last Post: 07-13-2007, 03:39 PM

Posting Permissions

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