Win a copy of Python Continuous Integration and Delivery this week in the Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Bear Bibeault
  • Paul Clapham
  • Jeanne Boyarsky
Sheriffs:
  • Devaka Cooray
  • Junilu Lacar
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Ron McLeod
  • Tim Holloway
  • Claude Moore
  • Stephan van Hulst
Bartenders:
  • Winston Gutkowski
  • Carey Brown
  • Frits Walraven

Quick Search Results page cant put multiple results into a table  RSS feed

 
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

I have a little problem regarding my quick results search page created with jsp and jstl. What is wrong is that after I submit my quick search jsp form and the servlet processes the request, the results page is not appearing, only stating that no books match my search criteria. So it is not forwarding to the results page, even though I know there are multiple results i nthe database which should be output to a table. Here is my code:





Again to clarify, I know my database has more than one search term such as different java books, but when I select "All" from my search form, and submit this, instead of forwarding this to the results page, it gives me an error that no resources match my search criteria. However, when I search for a specific title, the book will be displayed in the results table. How can I get my code to actually display all the results that match the search term provided by me?

Thanks if you can help.

 
Marshal
Posts: 24188
54
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You're asking why your query returns zero records? That sure looks like a JDBC question to me. Moving...
 
author & internet detective
Posts: 39148
724
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I see two things that are odd.
1) It looks like you only run the query if "all" is selcted? This seems like it isn't what you want.
2) The actual query looks for a title. If you are looking for "All", you'd need to omit the where clause.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!