help with ADO Sql statement

What is wrong with this code? It tells me missing operator error.
I want my results to be ordered by ProductCode and be between StartPlu and EndPlu...

rsOrderDetails.Open "SELECT * From OrderDetails ORDER BY ProductCode WHERE ProductCode >= " & StartPlu & " and ProductCode <= " & EndPlu & "", CN, , adLockOptimistic

Quote:

---

Originally posted by TSur
What is wrong with this code? It tells me missing operator error.
I want my results to be ordered by ProductCode and be between StartPlu and EndPlu...

rsOrderDetails.Open "SELECT * From OrderDetails ORDER BY ProductCode WHERE ProductCode >= " & StartPlu & " and ProductCode <= " & EndPlu & "", CN, , adLockOptimistic

---

Order By is ALWAYS the last thing in an SQL statement. Put the WHERE clause before it. :)

Try this:

VB Code:

rsOrderDetails.Open "SELECT * From OrderDetails WHERE ProductCode >= " & _
   StartPlu & " and ProductCode <= " & EndPlu & " ORDER BY ProductCode", _
   CN, , adLockOptimistic