How to restrict a perticular value of combo from displaying???

[Amulya]

Hi All,

Im using a query for listing all users in a combo.
The query is written in xml file, which is as follows.....

Select userid from sa_user where status=1;

Now my result set has some userids to display.
I dont want to display a perticular userid in combo.
Eg: My userids contains
aaa
bbb
ccc

My combo should contain only aaa and bbb not ccc.

How to implement this?

Im displaying combo like this........
User is my bean file and Xml file,where I wrote the query.





service.getGroupid((ListLoadConfig) loadConfig, new AsyncCallback() {
publicvoid onSuccess(Object result)
{
System.out.println("ON SUCCESS ===>"+result);
System.out.println("ON SUCCESS ===>"+(result instanceof BaseListLoadResult));
BaseListLoadResult listLoadResult = (BaseListLoadResult)result;
List<User> workGroups = listLoadResult.getData();
Iterator<User> iterator = workGroups.iterator();
while(iterator.hasNext()){

User wg = iterator.next();

}
reLoadCombo(workGroups);
}
}

[conorarmstrong]

would changing the sql to:



Select userid from sa_user where status=1 and sa_user.userid<>'ccc'


help you?