You could use addDynamicCriterion method to add dynamic criteria for the
dataobject(which
is binded to the master page). Do this on the button event of serach page.
But dont
execute it. Then load the master page. It should be working fine. Look
through the
sample code below:
//[[SPIDER_EVENT<onSearchWebEvent>
public int onSearchWebEvent( String args[] )
{
int command = PROCEED_WITH_BUILTIN_HANDLING;
CSpCriteriaSQLObject doPrd= (CSpCriteriaSQLObject) CSpider.getDataObject("doProduct");
// binded to the master page
doPrd.clearDynamicCriteria();
String snameStr=getDisplayFieldValue("tbName").stringValue(); //test box value on the
search page
if (snameStr.length() > 0)
doPrd.addDynamicCriterion("productShortName",CSpCriteriaSQLObject.CONTAINS_STR_OPERATOR,new
CSpString(snameStr));
command = load("masterPage")
return(command);
}
Jay Arumugam
"shuba natarajan" <[EMAIL PROTECTED]> wrote:
>
>Hi All
>I'm using Net Dynamics ver 3.12. All I want is to display the records with some
>search criteria using a search and master page.
> I tried the following. I have a Data Object built through the studio and it is a
>simple select Data Object.
>In my search page I have 5 textboxes. I carry the textbox data to the master page
using session objects. On the masterpage under "On Before Display Event" I
retrieve
these session values(text box values from the search page) and have a dynamic
sql
string. Using "SetSqlTextFull" I'm trying to execute the DataObject and
checking
the results. But what I find is the repeated object is getting overridden by
the
standard SQL instead of the dynamic. Could somebody please suggest some help.
>thanks in advance
_________________________________________________________________________
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]
