• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Not able to run the query in MS access

 
sruthi das
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I want to get all the names when I give firstletter.Query is like this.Ex:When I give fname as 'a' in jsp
then all names starts with 'a' has to come.Here I am using MS Access
select Employee_FName from UserTable where Employee_FName like '"+fname+"%'";
here fname I am getting from jsp.
I am not able to run this query.
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It would be easier if you showed us the code rather than just the query.

Also, I once had a friend who's first name was D'arcy, can you try your code using his name please?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic