Keep getting this error msg... 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

[shanePreater]

You have an extra " in your addToWhereAnd methods parameter:

Code:

dropDown.addToWhereAnd("TechnologyType IN (SELECT TechnologyType FROM Site WHERE ApplicationID=" + applicationID + "AND TechnologyType" = 1 ") ");