New to Java Please Help

[kee2ka4]

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]

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]

Maybe from breaking up a string improperly. Try this:

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

[kee2ka4]

Thanks it's working now.. Thank You