MySQL problem

Hello, y'all.
The question is - where is syntax mistake?

Code:

---

st = "select * from schedule left join students on schedule.Students_id = students.id HAVING schedule.courses_id=?";
PreparedStatement s=dbConnection.prepareStatement(st);
s.setInt(1, Integer.parseInt(paramArray.get(0).toString()));

---

The exception tells you where. Maybe if you were to post that we could help you correct it.

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?' at line 2"

Should that be a WHERE rather than a HAVING?

I tried WHERE already and had the same result.

when I query using MySQL Workbench, this works fine:
select * from schedule left join students on schedule.Students_id = students.id HAVING schedule.courses_id=1

Quote:

---

Originally Posted by indra-uolles

I tried WHERE already and had the same result.

---

According to this page the syntax of your SQL query is indeed incorrect.

kind regards,

Jos

Quote:

---

Originally Posted by indra-uolles

when I query using MySQL Workbench, this works fine:
select * from schedule left join students on schedule.Students_id = students.id HAVING schedule.courses_id=1

---

yes, but HAVING is usually used with GROUP-BY-clause, so if you don't have any grouping function in the SELECT-clause like (count, min, max) use WHERE.

When debugger reaches the line

Code:

---

s.setInt(1, Integer.parseInt(paramArray.get(0).toString()));

---

I evaluate the expression Integer.parseInt(paramArray.get(0).toString()) and I see that it's "(int) 1".
So it seems to be ok here too...

Just to double check, is courses_id an inte and not a varchar (for example)?

Quote:

---

Originally Posted by Tolls

Just to double check, is courses_id an inte and not a varchar (for example)?

---

Type clashes should never cause syntax errors because the type system hits in after the syntax checks (parsing) has been done.

kind regards,

Jos

yes, it's int.

Quote:

---

Originally Posted by indra-uolles

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?' at line 2"

---

The other indications given above are also correct, but from this error, let me guess, you are doing

Code:

---

s.execute(st);

---

or

Code:

---

s.executeQuery(st);

---

Well, don't include the argument/parameter in that call.

Quote:

---

Originally Posted by JosAH

Type clashes should never cause syntax errors because the type system hits in after the syntax checks (parsing) has been done.

kind regards,

Jos

---

Ah yes, good point.
I was flailing a bit, it must be said.

Quote:

---

Originally Posted by masijade

The other indications given above are also correct, but from this error, let me guess, you are doing

Code:

---

s.execute(st);

---

or

Code:

---

s.executeQuery(st);

---

Well, don't include the argument/parameter in that call.

---

Ah.
I wonder if we have a winner here?

masijade, thanks a lot :)