• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

multiple search/sql

 
eric clark
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 6920
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanx, managed it btw, with getting some sql book
grtx eric
 
Frank InTheHouse
Greenhorn
Posts: 3
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic