1,105,534 Community Members

java with msaccess

Member Avatar
Pushpasheela
Newbie Poster
13 posts since Sep 2010
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
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.

Member Avatar
peter_budo
Code tags enforcer
7,939 posts since Dec 2004
Reputation Points: 2,502 [?]
Q&As Helped to Solve: 1,028 [?]
Skill Endorsements: 66 [?]
Moderator
Featured
 
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 three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article