java with msaccess

 
0
 

I want to fetch data from msaccess database using like. but my query not run.
Here is my code.

String pin=cmblocation.getSelectedItem().toString();
rs2=st2.executeQuery("Select * from pin_numbers where pin_number like 'pin&????'");

. But my query is not run. Please help me.

 
0
 

Do you think that query is correct? I don't. If you do not believe me try to execute directly on database (command line or gui tool). What are you trying to pass as "pin&????" ?

You
This article has been dead for over six months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article