3 Replies Latest reply: Apr 25, 2009 9:30 PM by 807588 RSS

    java MS ACCESS query problem

      I have a java program which makes use of ms access as it's database.

      I have this query
      ResultSet rs = statement.executeQuery("SELECT * FROM table LIKE '*some wordd*'");
         System.out.println("There's an output");
         System.out.println("Nothing was queried.. what the hell is wrong?");
      As you can see, i'm trying to make use of the LIKE query... Now here's the problem, I dont get any result if the code above gets executed by my java program... BUT, if I copy the SQL statement and PASTE it in MS ACCESS's query section, IT WORKS and something was queried.... now where did I go wrong? does this has something to do with the "*" character on the executeQuery method of statement? Cause "*" is the wild card character for ms access.