Subject : .


Dear sir :

    I have built a list which get populated based on a query from an access data source , I try

to use the string retrived from this list in the where condition of another - dynamic - qury ,

but my code didnt work please help me

  A string St1 is passed to Jlist , when item of this list get selected an event lunch another qury based

 on this St1 but this didnot work .





The list was implimented in this way :

    List sampleJList ;

 then was populated using the following qury :

ClientsNamesRetrival = " SELECT CLIENT_NAME AS CN FROM CLIENTS ";

entries[mm++] = TheResultSet.getString("CN");

sampleJList = new JList(aaa.entries);

Then when I select an Item to the following code should perform a qury based on the sellection result

but this code having problem :

    if (!event.getValueIsAdjusting())

{ valueField.setText( (SelectedClient = sampleJList.getSelectedValue().toString()));






try
                {

ClientsNamesRetrival = " SELECT TRIM( INCHARGE_PERSON ) AS IC FROM CLIENT_PERSONS "
                      + " WHERE CLIENT_NAME Like ' CStr(SelectedClient) *'" ;