sql WHERE error

can you post your SQL statement here?!?

We need to see the querys !!

Is java.SQLException: syntax-error in WHERE the hole error message ???

Post the code that don't work - please..

OK... here's the connection:

    public static void connect (){

    try{
        // DatabasDriver
        Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );

        // DatabasKoppling
        connection = DriverManager.getConnection("jdbc:odbc:speak", "jacob", "nowijustwrotesomthinghereforekspertview");
    }catch(Exception e){}
}




Here's the method that works:

public static void speak (String x){

        try {
        String say = "<html><u>You</u>: "+x+"</html>";
        write(say);
        databaseid = "analyze";
        runqueries = true;


        connect();

        StringTokenizer sentence = new StringTokenizer (x);

        // Loopen som ställer frågor
        while (sentence.hasMoreTokens() & runqueries) {

        // Fråga
        PreparedStatement preparedStatement = connection.prepareStatement("SELECT databaseid, group FROM "+ databaseid +" WHERE inword ='"+ sentence.nextToken() +"';");

        // Ställ frågan
        ResultSet databaseids = preparedStatement.executeQuery();

        // Spara databaseid i String
        while(databaseids.next())
                {
            databaseid = databaseids.getString("databaseid");
            group = databaseids.getString("group");
            }
            System.out.println("Group is:"+group);//TA BORT

            if (databaseid.equals ("answer")) {runqueries = false; getanswers(); String y = random(answersarray); System.out.println("ggooogel"); answer = "<html><u>Waldo</u>: "+ y +"</html>"; write(answer);}

        }//slut-på-loop

    if (runqueries) {answer = "<html><u>Waldo</u>: Waldo don't understand..</html>"; write(answer);}

        } catch (Exception e) {e.printStackTrace();}
    }



And here is the one where the problem is:

// Hämtar svaren och sätter dem i en array
    public static void getanswers() {

    try{
        // DatabasDriver
        //Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
        connect();
        // DatabasKoppling
        //Connection connection = DriverManager.getConnection("jdbc:odbc:speak", "jacob", "maxell");
            System.out.println(databaseid);//FELSÖK

      PreparedStatement getanswers = connection.prepareStatement("SELECT outword FROM "+ databaseid +" WHERE group ='"+group+"';");
      //PreparedStatement getanswers = connection.prepareStatement("SELECT outword FROM " + databaseid+ " WHERE group like '1%';");
      //PreparedStatement getanswers = connection.prepareStatement("SELECT outword FROM answer");
        System.out.println("förbi prepare");//FELSÖK
        ResultSet answers = getanswers.executeQuery();
        System.out.println("förbi execute");//FELSÖK


        int x = 0;
        while(answers.next()) {
        answersarray [x] = answers.getString("outword");
        System.out.println(answersarray [x]);
        x++;
            }

    } catch (SQLException e){e.printStackTrace();}
        }


All methods are in the same class, don't think about variables, some are declared globally, but they do what I want them to do, I've checked that.

GROUP er et reserveret ord.

GROUP is an reserved word.

Try call your field something else.

so I can't use it in my database-column?

No I think that is the problem.

try rename it io questiongroup, answergroup, usregroup or somethinggroup.

Yeeey! It worked.. Should have known that myself.. but It's stupid that access didn't warn me about the name :s
Thank u!
PS. make "Svar" maybe?

answer