Results 1 to 2 of 2
  1. #1
    kee2ka4 is offline Member
    Join Date
    Aug 2007
    Posts
    3
    Rep Power
    0

    Default Keep getting this error msg... Please help?

    Hello Everyone..

    I keep getting the following message: ')' Expected but I don't know why.. The Method is as follows:

    public void createTechnologyList(int applicationID) {
    dropDown.addToWhereAnd("TechnologyType IN (SELECT TechnologyType FROM Site WHERE ApplicationID=" + applicationID + "AND TechnologyType" = 1 ") ");

    dropDown.retrieve();
    resetCounter();
    items = dropDown.resultSet();

    }

    Could you please help?

    Thanks in advance
    Kets

  2. #2
    shanePreater is offline Member
    Join Date
    Jul 2007
    Location
    England, Bath
    Posts
    47
    Rep Power
    0

    Default

    You have an extra " in your addToWhereAnd methods parameter:
    Java Code:
    dropDown.addToWhereAnd("TechnologyType IN (SELECT TechnologyType FROM Site WHERE ApplicationID=" + applicationID + "AND TechnologyType[COLOR="DarkRed"]"[/COLOR] = 1 ") ");

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •