Kirix Support Forums

Choicebox onchange

Please post any help questions, requests or other feedback here.

Choicebox onchange

Postby abenitez77 on Wed Apr 27, 2011 5:52 pm

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
Registered User
 
Posts: 141
Joined: Fri Jan 21, 2011 12:42 pm

Re: Choicebox onchange

Postby abenitez77 on Mon May 02, 2011 3:36 pm

figured it out...
abenitez77
Registered User
 
Posts: 141
Joined: Fri Jan 21, 2011 12:42 pm

Return to Strata Help & Feedback