Syntax Error in Query expression

[Manfizy]

Hi guys,
Am using MS Access database.
To access data from the database, i use the following query

String query = "SELECT * FROM PathConfig WHERE AcademicYears = '"+acadYr+"'_StudentResults.xls";

On executing the above query, i get a syntax error "java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in query expression 'AcademicYears = '2009_2010'_StudentResults.xls'."

Anyone with an idea on how i can solve this error??

Your response will be highly appreciated.

Cheerz!!:(

[masijade]

What is

'xxxxxx'_StudentResults.xls

(with xxxxx being the value of acadYr) suppossed to be?

Do you know SQL at all?

[Manfizy]

What is

'xxxxxx'_StudentResults.xls

(with xxxxx being the value of acadYr) suppossed to be?

Do you know SQL at all?

'xxxx' or whatever you want to call it, its string variable that is supposed to be combined with _StudentResults.xls to make up a complete string. For instance, 2009_2010_StudentResults.xls:confused:

[Manfizy]

Figured it out and i know sql!!!!

[masijade]

Figured it out and i know sql!!!!

Really? That quoted piece didn't really look like it. You should be looking at PreparedStatement, you know?