wood burning stoves
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
JavaRanch » Java Forums » Java » Servlets
Bookmark "multiple search/sql" Watch "multiple search/sql" New topic

multiple search/sql

eric clark

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

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

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

Joined: Feb 19, 2001
Posts: 3
Check this out:
I agree. Here's the link: http://aspose.com/file-tools
subject: multiple search/sql
It's not a secret anymore!