I'm trying to use a CSpSelect in PARTIAL_TEXT_OVERRIDE
mode. My dataobject has a query set in the studio that
looks like "select a,b,c from x where a=1" and then in the
do's onBeforeExecute event I use setSqlTextJoin("b=2"). The
first time I run the page the results do not reflect the
setSqlTextJoin criteria. When I click the reload button in
the browser (and every subsequent access to the page until I
clear cache) the results are the combination of the query
and the setSqlTextJoin criteria. I know that this type of
thing is more easily done using addDynamicCriterion but in
this case we have other requirements that prevent us from
doing this, ie. we are also changing the columns selected at
times using setSqlTextSelect(), etc.
Can anyone tell me why the entire criteria is not effective
on the first access.
Thanks for the help.
Fred
--
Fred Bruegmann
Lead Electronic Commerce Analyst
Whirlpool Corporation
Phone: (616) 923-3751
Fax: (616) 923-4667
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]
