This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes Servlets and the fly likes Wild card search with MSAcess and Servlets Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Java » Servlets
Bookmark "Wild card search with MSAcess and Servlets" Watch "Wild card search with MSAcess and Servlets" New topic
Author

Wild card search with MSAcess and Servlets

Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
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

Joined: Nov 22, 2008
Posts: 18944
I have used the SQL construct "... like '%...%' ..." successfully in Access. Is that what you are looking for?
Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
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
 
GeeCON Prague 2014
 
subject: Wild card search with MSAcess and Servlets