Hi, all
I have a DAP page with a dropdownlist which I tried to list items according the ServerFilter. Suppose the dropdownlist is as following:
ListRowSource->Recordset: APPLN_APPLT1
ListDisplayField->PVP_NO2: PVP_NO
ListBoundField-> PVP_NO3: PVP_NO
I try to apply the filter with in javascript:
MSODSC.RecordsetDefs.Item("APPLN_APPLT").ServerFilter ="CTRY_INCORP_CITIZEN = '"+strValue+"'";
What I expected is the dropdownlist list the items while CTRY_INCORP_CITIZEN = '"+strValue+"'", for example, CTRY_INCORP_CITIZEN = 'us';
Firstly, I tried the DAP with a Access database, it works very good, the dropdownlist changed when the ServerFilter changed.
But when I try the same code in a DAP with Sql Server 2005 Express. The dropdownlist does not change while the recordset filters correctly.
Does the DAP serverfilter work on Sql Server?
Help! Thanks
I have a DAP page with a dropdownlist which I tried to list items according the ServerFilter. Suppose the dropdownlist is as following:
ListRowSource->Recordset: APPLN_APPLT1
ListDisplayField->PVP_NO2: PVP_NO
ListBoundField-> PVP_NO3: PVP_NO
I try to apply the filter with in javascript:
MSODSC.RecordsetDefs.Item("APPLN_APPLT").ServerFilter ="CTRY_INCORP_CITIZEN = '"+strValue+"'";
What I expected is the dropdownlist list the items while CTRY_INCORP_CITIZEN = '"+strValue+"'", for example, CTRY_INCORP_CITIZEN = 'us';
Firstly, I tried the DAP with a Access database, it works very good, the dropdownlist changed when the ServerFilter changed.
But when I try the same code in a DAP with Sql Server 2005 Express. The dropdownlist does not change while the recordset filters correctly.
Does the DAP serverfilter work on Sql Server?
Help! Thanks
