File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Wild card search with MSAcess and Servlets
 
Similar Threads
Failed to insert a record into MSAcess
Need to perform wildcard search
configuring tomcat to use MsAcess
Failed to insert a record into MSAcess
How can i search?