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

    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 is offline Senior Member
    Join Date
    May 2008
    Makati, Philippines
    Rep Power


    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, 05: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