Try to execute the sql using execute() and execute the doAutoLoad() method of the
combo box.
Try to do that in onbeforeload of the page and see if that works.
I do not know why your logic did not get execute.
This at least will proof whether your logic is correct or not.
The worst case is you are executing the data object twice.
"Howarth, Dan" <[EMAIL PROTECTED]> wrote:
>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]
