Notifikationer

Markér alle som læst Log ud

holmqvist Nybegynder

27. oktober 2003 - 15:58 Der er 10 kommentarer og
1 løsning

sql WHERE error

I've done an application where I run queries to a database. The first question I made worked very well... but then when I did another query in an other method I got:
java.SQLException: syntax-error in WHERE. When I remove WHERE the query works.. what could be wrong? I have checked all the variables that I use in the question and I connected to the database in that method aswell, the same way I did in the first method that worked..

Synes godt om

nibx Nybegynder

27. oktober 2003 - 16:03 #1

can you post your SQL statement here?!?

Synes godt om

henriktha Nybegynder

27. oktober 2003 - 16:04 #2

We need to see the querys !!

Synes godt om

europe Nybegynder

27. oktober 2003 - 16:07 #3

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

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

Synes godt om

holmqvist Nybegynder

27. oktober 2003 - 16:18 #4

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>You: "+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>Waldo: "+ y +"</html>"; write(answer);}

}//slut-på-loop

if (runqueries) {answer = "<html>Waldo: 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.

Synes godt om

arne_v Ekspert

27. oktober 2003 - 16:29 #5

GROUP er et reserveret ord.

Synes godt om

arne_v Ekspert

27. oktober 2003 - 16:29 #6

GROUP is an reserved word.

Synes godt om

arne_v Ekspert

27. oktober 2003 - 16:29 #7

Try call your field something else.

Synes godt om

holmqvist Nybegynder

27. oktober 2003 - 16:30 #8

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

Synes godt om

arne_v Ekspert

27. oktober 2003 - 16:32 #9

No I think that is the problem.

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

Synes godt om

holmqvist Nybegynder

27. oktober 2003 - 16:41 #10

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?

Synes godt om

arne_v Ekspert

27. oktober 2003 - 16:46 #11

answer

Synes godt om

Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Følg dette spørgsmål

Opret Preview

Programmeringssprog kurser

Kurser inden for grundlæggende programmering

Se alle Programmeringssprog kurser

Flere spørgsmål fra Java kategorien

Titel	Indlæg	Oprettet	Seneste aktivitet
Programmering: Produktmixoptimering Af OBS i Java	34	23/05/202513:55	27/05/202518:32
Seleniumspørgsmål vedr. getText() Af mergelspir i Java	11	08/05/202516:32	08/05/202522:16
eclipse Af OBS i Java	0	02/05/202512:51	-
eclipse Af OBS i Java	14	27/04/202521:14	28/04/202521:28
eclipse Af OBS i Java	2	18/04/202517:14	18/04/202519:52

Se alle spørgsmål i kategorien Opret spørgsmål

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester

Alle kategorier på Eksperten

Seneste artiklerRSS