2. PHPRunner General questions
  3. need to change WHERE clause in the details page
This topic is locked

need to change WHERE clause in the details page

 		12/28/2012 1:59:37 AM
PHPRunner General questions
D
 desipan author

I have Master / Details list pages. Table1 list page is a Master Page and Table2 list page is a Details Page linked by their ID fields. Whenever one of the Table2 Details link on the Master Page is clicked, it needs to pass the Date1 field value from table1 as a parameter to its Details Page. On the Detail Page the WHERE clause needs to be modified so the Detail Page would display all the records within 7 days from Date1 parameter in the future, in another phrase (Date1 =< Today+6). Please tell me how to accomplish this task.
M
 		mrdave 12/28/2012

Look up dynmic SQL.

in the Add the following code to the After table initialized event.
$query->addWhere("") command
D
 		desipan author 12/28/2012



Look up dynmic SQL.

in the Add the following code to the After table initialized event.
$query->addWhere("") command


I tried your suggestion and inserted replaceWhere() command instead of addWhere() since I am trying to replace with new conditions in WHERE clause. It is still attaching the original condition along with new ones and not completely being replace with the new ones. How can I solve this issue?