Try to remove the static on your genDObj. It might be that it
is being cleared by other project instance.
Suyoto.
Curt Springer <[EMAIL PROTECTED]> wrote:
>2 factors I can think of might apply here:
>
>1. The CSpProject class is tricky. It was created mostly for ND's
>purposes, and problems can arise when you use it for other purposes.
>2. data objects execute in the context of sessions. I think that in
>'init' processing, before real sessions, there is a 'faux' session. The
>data obj 'get num of rows' method is a convenience method that operates on
>the data object's last result set in the context of a session. When you
>call it in a real session you will not get the results from init processing.
>
>It appears that you are trying to preload a listbox from a data object
>execution before any sessions have happened. I would suggest that in the
>page's onafterinit event, you execute the DO and load the listbox.
>
>-- Curt Springer, Team ND
>
>At 03:24 PM 1/10/00 -0800, Keith Knaide wrote:
>
>>I have definded a variable at the project level as follows:
>>
>> public class KeithTestProject extends spider.CSpProject
>> //]]SPIDER_CLASS END
>> {
>> protected static CSpCriteriaSQLObject genDObj;
>> .
>> .
>> .
>>
>>Then I execute a data object as follows:
>>
>> public int this_onAfterInitEvent(CSpInitEvent event)
>> {
>> // This event runs the data object to fills the State
>> Code picklist
>> //CSpHtml.sendMessage("got here");
>> genDObj = (CSpCriteriaSQLObject)
>> CSpider.getDataObject("doStates");
>> genDObj.clearDynamicCriteria();
>> genDObj.addDynamicCriterion(
>> "df_CED_STATE_CODE_COUNTRYCD_CODE",
>>
>>CSpCriteriaSQLObject.EQUAL_TO_STR_OPERATOR,
>>
>>new CSpString("US"));
>> genDObj.execute();
>>
>> if (genDObj.succeeded())
>> {
>> CSpHtml.sendMessage("Execute OK " +
>> genDObj.getNumOfRows());
>> rowcount = genDObj.getNumOfRows();
>> }
>> else
>> {
>> CSpHtml.sendMessage("Error Executing Data Object");
>> }
>> return (PROCEED);
>> }
>>
>>I know it successes, because I see the message "Execute OK 164".
>>However, in a page within the project, I attempt to reference the data
>>object as follows
>>but receive a NullPointerException
>>
>> public int cbStates_onBeforeDisplayEvent(CSpDisplayEvent event)
>> {
>> CSpHtml.sendMessage("Rows= " +
>> KeithTestProject.genDObj.getNumOfRows());
>> return (PROCEED);
>> .
>> .
>> .
>> }
>>
>>Why is this not valid; why don't I see "Rows=164"????
>>_________________________________________________________________________
>>
>>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]
>
_________________________________________________________________________
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]
