This topic is locked
[SOLVED]

 Urgent Help: ItemMenu event and Where SQL

9/6/2010 6:01:27 PM
PHPRunner General questions
A
anjeko author

Plese, Please help me do the following:
I have one list form which need to be executed with 2 different WHERE SQL param.

User have 2 menu items for "Open" job and "Closed" job, when clickin on "open" I need to get item menu id (or param?) and got to other event to modify WHERE SQL statement.

I tried on many ways and I am not getting any info/param when I clocked on MenuItem control!!!

I need thsi solution asap or I will need to multiply same forms with different WHERE statemens.
Thanks for you attention and help
Jerry

W
wildwally 9/7/2010



Plese, Please help me do the following:
I have one list form which need to be executed with 2 different WHERE SQL param.

User have 2 menu items for "Open" job and "Closed" job, when clickin on "open" I need to get item menu id (or param?) and got to other event to modify WHERE SQL statement.

I tried on many ways and I am not getting any info/param when I clocked on MenuItem control!!!

I need thsi solution asap or I will need to multiply same forms with different WHERE statemens.
Thanks for you attention and help
Jerry


Not sure if I understand you correctly, but it sounds like you want the menu to do two different queries (one WHERE = Open and the other Where = Closed)
Possible solution is using views. Create copies of the original table one with a filter for Open and the other filtering Closed. Then you have the two pages you are looking for.
If not what your looking for, might suggest more detail.
Thats my $0.02

A
anjeko author 9/12/2010



Not sure if I understand you correctly, but it sounds like you want the menu to do two different queries (one WHERE = Open and the other Where = Closed)
Possible solution is using views. Create copies of the original table one with a filter for Open and the other filtering Closed. Then you have the two pages you are looking for.
If not what your looking for, might suggest more detail.
Thats my $0.02


Not this problem:
What I want is simple get number/name of menu item clicked selected from top menu list.

When I have this info I can save in SESSION and modify later WHERE SQL when displaying list of records.
I have been using the following code with MO DATA RETURNED!!!!
if($menuItem->getLinkType() == 'Internal'){

if ($menuItem->getTitle() == 'Customers'){;

$menux = $menuItem->getParams();

print "test menu 1 ";

// this code will not return any value/data from getTitle() - why?????????

}

$menux = $menuItem->getTitle();
print "test menu all = $menux ";

// above code returns all menu items ( I need only one I clicked ) why ???

}