#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    chennai, tamil nadu, INDIA
    Posts
    27
    Rep Power
    0
    String fexp="";
    fexp=request.getParameter("fexpcujob");

    String ftq="";
    ftq=request.getparameter("ftechquali");

    here jobreg is the table name and expcujob, quali is the field name.

    String query = "SELECT * FROM jobreg WHERE jobreg.expcujob=" + fexp;
    this is working for only one search condition.

    if i give two search condition, the below query is not working.
    String str_query2 = "SELECT * FROM jobreg WHERE jobreg.expcujob && jobreg.quali=" + fexp ,+ ftq;

    kindly send the immediate reply.


  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Posts
    1
    Rep Power
    0
    Your syntax is incorrect. Change the && to AND

IMN logo majestic logo threadwatch logo seochat tools logo