Hi...
I'm trying to equal an ID which is taken as user input in an sql staement as below..
int answer = Integer.parseInt(mainMenu.client);
ResultSet rs = st.executeQuery("select * from Client where CliId = answer ");
Give the error, java.sql.SQLException: ORA-00904: invalid column name
Pls help.. Tnx..
I'm trying to equal an ID which is taken as user input in an sql staement as below..
int answer = Integer.parseInt(mainMenu.client);
ResultSet rs = st.executeQuery("select * from Client where CliId = answer ");
Give the error, java.sql.SQLException: ORA-00904: invalid column name
Pls help.. Tnx..