This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Servlets and the fly likes multiple search/sql 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 "multiple search/sql" Watch "multiple search/sql" New topic
Author

multiple search/sql

eric clark
Greenhorn

Joined: Jan 18, 2001
Posts: 16
hithere. just stuck on some jsp/sql coding. i did a database with pictures. and a jsp form with 5 fields, where 1 has to be filled, 5 can be filled, now i wanna search the db with criterias from the fields. some1 could explain me how this works?
im also stuck on the sql for this..
thx eric
Frank Carver
Sheriff

Joined: Jan 07, 1999
Posts: 6920
Well we'd need to know a little more about the structure of your data. Is it in a single table (sounds like it)? Are the fields in the form applicable to separate database fields or are they "keywords" from a single field?
You obviously need to generate some sort of SELECT statement, but for any more answers we need a little more detail in the question.


Read about me at frankcarver.me ~ Raspberry Alpha Omega ~ Frank's Punchbarrel Blog
eric clark
Greenhorn

Joined: Jan 18, 2001
Posts: 16
thanx, managed it btw, with getting some sql book
grtx eric
Frank InTheHouse
Greenhorn

Joined: Feb 19, 2001
Posts: 3
Check this out:
http://www.jspinsider.com/beans/snippets/database/HashTables.txt
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: multiple search/sql
 
Similar Threads
Right Justify---zero fill
How to perform validation conditionally ?
can't get indexed form property to work.
Search best way
Sql Where clause and/or issues