• 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?
 
It is an experimental device that will make my mind that most powerful force on earth! More powerful than this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!