New to Java Please Help

**kee2ka4** · 08-13-2007, 04:18 PM

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

**cruxblack** · 08-13-2007, 04:58 PM

Please please please please, do not double post, u already post the same question in Java EE thread
Keep getting this error msg... Please help?

Please read the FAQ and rules thread if u havent done it before
http://www.java-forums.org/faq.php?faq=forumrules

Bout ur code, i don't dwell in J2ee, but so far i see no wrong, can't help u there, sorry

**hardwired** · 08-13-2007, 09:58 PM

Maybe from breaking up a string improperly. Try this:

Java Code:

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();
}