Syntax Error in Query expression

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

Code:

---

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!!:(

What is

Code:

---

'xxxxxx'_StudentResults.xls

---

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

Do you know SQL at all?

Quote:

---

Originally Posted by masijade

What is

Code:

---

'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:

Figured it out and i know sql!!!!

Quote:

---

Originally Posted by Manfizy

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?