Choicebox onchange

[abenitez77]

I have a choicebox with a list of items and I want to populate choicebox2 with items from a sql table filtered by the selection in choicebox. This is not complete...but I was thinking of putting this code below on the "OnChange" property of my choicebox. What is the correct syntax to do this?

//Connection
var dbP
var tblinfo
dbP = new DbConnection("mssql://USATL02PRSQ70:1434/STRATA");
var MyClients = dbP.execute("select ProjectName from projects where ClientName = ' " + choicebox + " ' ");
while (MyClients.next())
{
choicebox2.addItem(MyClients.ProjectName);
}

[abenitez77]

figured it out...