multiple search/sql

[eric clark]

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]

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.

[eric clark]

thanx, managed it btw, with getting some sql book
grtx eric

[Frank InTheHouse]

Check this out:
http://www.jspinsider.com/beans/snippets/database/HashTables.txt