Jump to content
  • 0

Help With a Syntax Error


Urbanhack

Question

Hello Guys.. Some One Can Help Me With This Error:

Here Is The Error In Console:

 

errorsql.jpg

 

And This Is The Java Code:

PreparedStatement statement = con.prepareStatement("" + "SELECT" + "characters.charId," + "characters.char_name" + "FROM" + "characters.account_name = accounts.login" +"WHERE" + "characters.onlinetime > 0" + "GROUP BY" + "accounts.lastIP" + "ORDER BY" + "characters.level" + "DESC");

 

Thx A Lot!

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0

use

PreparedStatement statement = con.prepareStatement("SELECT charId, char_name FROM characters WHERE account_name = ?");
statement.setString(1, "The_Account_name_goes_here");

 

Your error is caused because you dont let spaces anywhere, and the mysql engine cannot distinct between commands, columns and parameters

 

Link to comment
Share on other sites

  • 0

Then.. This Is Right?:

 

PreparedStatement statement = con.prepareStatement("" + "SELECT" + " characters.charId," + " characters.char_name" + " FROM" + " characters.account_name = accounts.login" +" WHERE" + " characters.onlinetime > 0" + " GROUP BY" + " accounts.lastIP" + " ORDER BY" + " characters.level" + " DESC");

Link to comment
Share on other sites

  • 0

i still dont understand why you use "string" + "string" + etc...

Also, you dont need to specify the table name before the column to call

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.


×
×
  • Create New...