• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Wild card search with MSAcess and Servlets

 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Friends,
Can anyone send a correct Sql query embdedded in servlet code for wild card search with MSAcess database. Kindly test it as It is not working after trying it for many times. It works fine with oracle database but not with MSAccess.
bye,
shiva
 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have used the SQL construct "... like '%...%' ..." successfully in Access. Is that what you are looking for?
 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Brian,
Thanks for the feedback. But u know I need to embed this is in the servlet. That is where the problem is. Directly with MSAccess it works fine. Let me once u successfully do it embedding in servlet.
Thanks,
shiva
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic