I have a Combo Box that is populated with a Data Object. In the
onBeforeExecuteEvent for the data object I have the following
code which builds the required SQL:
CSpValue custID = CSpider.getUserSessionObject("usUserID");
CSpDBSQLRequest theReq = (CSpDBSQLRequest) event.getDBRequest();
String modifiedSQL = "Select ALL dbo.Web_Xref.CUSTOMER_ID," +
"dbo.Web_Xref.STATION_ID from dbo.Web_Xref " +
"Where CUSTOMER_ID = '" +
custID.toString() + "'";
theReq.setSQLProgram (modifiedSQL);
Note that the Where clause is based on a User Session Object called custID.
This
works fine the first time I execute my page, but on subsequent executions in
which
the value of the custID is different the exact same result set is returned.
I looked
in the NetD log and the SQL statement is not even being executed. It's like
the
entire SQL statement and result set is cached, but it shouldn't be.
How do I force the modifiedSQL statement for the data object associated
with the Combo Box to execute everytime the page is loaded?
Any help on this is much appreciated.
PG&E Gas Transmission Texas and any other company referenced herein which uses the
PG&E name or logo are not the same company as Pacific Gas and Electric Company, the
California utility. These companies are not regulated by the California Public
Utilities Commission, and customers do not have to buy products from these companies
in order to continue to receive quality regulated services from the utility.
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
