autoNumber problem with MS access

[taha khalid]

Hi

I'm trying to make a search bar in java that searchs through a MS access DB .. specifically in a field that holds autoNumber format variables .. the problem that I have is the variable that gets the search value from a text field (I converted it to integer to be comparable with the autoNumber ) this approach is not working but when I change the variable that gets the text field from integer to string and change the autoNumber to a string value the code works.

            String ID =  is_ID.getText().trim();
            int a=  Integer.parseInt(ID);

            String sql = "select ID from student_info where ID ='"+a+"'";

            rs = st.executeQuery(sql);

            
            int count = 0;
            while (rs.next()) {

                count = count + 1;
            }
            if (count == 1) {

               match.setText("match");
               
            }

Please help

[Wei Dai]

Try

String sql = "select ID from student_info where ID ='"+a+"'";  // your line
String sql = "select ID from student_info where ID ="+a;  //Wei's suggestion

[Wendy Gibbons]

Hi you two I have added code tags to both of your posts, see how much nicer it looks.
For starters you can tell which quotes you have.

[Baseet Ahmed]

AsSalaamualaikum Taha khalid:

String sql = "select ID from student_info where ID ='"+a+"'";

What is the data type of your ID column in MS Access DB?

You are using variable a with single quote(' '). So check if it Integer(Number) or string(Text).


--------
Regards
Ahmed