Piet Souris wrote:hi Gourav,
indeed, if one of the fields is empty, then you do a query that looks for
an empty field in your database. And if there is no such field , then
indeed, you get an empty result.
Easiest that I can think of is to use a StringBuilder first.
Append the 'Select (...)', and then go through all textfields like:
et cetera. Then issue 'pst=conn.prepareStatement(sb.toString);'
Greetz,
Piet
oh man thanks!! you literally saved me.
one more question..how can i append "; in last to complete the query in the StringBuilder? any special format?