2. PHPRunner General questions
  3. Lookup Table where clause
This topic is locked

Lookup Table where clause

 		1/7/2008 11:20:53 AM
PHPRunner General questions
jpedwardspost author

Hi,
I would like to restrict the number of items that are available in a list of values lookup field.
In the where clause I have tried this kind of thing: "owner_id = " . $values["owner_id"] but with no success.
I know that $values["owner_id"] can be used when writing php script for Events.
Can $values["owner_id"] be used in the lookup where clause and if not how can I achieve what I am trying to do.
Thanks

JP.
F
 		frocco 1/7/2008

Try something like this.
"owner_id = " . $_SESSION["UserID"]
HTH
Frank
J
 		Jane 1/9/2008

Hi,
use $_SESSION["_TableName_OwnerID"] instead of $values["OwnerID"]:

"owner_id = " .$_SESSION["_TableName_OwnerID"]