#2 SQL statement missing FROM keyword

closed-fixed
nobody
None
5
2003-01-14
2003-01-01
Kenneth Stout
No

The generated DAO SearchByXXX method for a query is
missing the FROM keyword.

...snip...
public List SearchByRole(int offset, int limit,
String role) throws SQLException {
ArrayList list = new ArrayList();
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
conn = ds.getConnection();
String sql = "SELECT password, firstname,
lastname, email, birthdate, role, username users";
sql += " WHERE role =?";
sql += " ORDER BY firstname , lastname ";
pstmt = conn.prepareStatement(sql);
...snip...

Using version 1.1.2

Thanks,
Kenneth.

Discussion

  • Kenneth Stout
    Kenneth Stout
    2003-01-14

    • status: open --> closed-fixed