2. PHPRunner General questions
  3. Three level lookup troubles
This topic is locked

Three level lookup troubles

 		12/7/2006 4:44:43 PM
PHPRunner General questions
J
 Jkelleyus author

You folks are so helpful... but here is one I'm stumped on.
I have a database called scrap. It tracks product that has been manufactured but rejected.
The form to enter this information is fairly straight forward, but I'm trying to make it as fool-proof as possible.
The form uses three lookup boxes. The first inserts a customer ID from the customer database.
The second is dependent on the first and allows the user to select only a parts ID... based on the customer ID, from the parts database.
These two work flawlessly.
The third is the one giving me trouble. I want it to list production dates based on the parts ID and give the user a selection of dates to be used as production ID in the scrap database.
phpRunner pulls the correct available production dates accurately, and in the TEST mode does so in descending order. However, when the page is built the control actually pulls the lookups in ascending order.
What the heck am I doing wrong here?
Thanks,
Jake
J
 		Jane 12/8/2006

Jake,
thank you for pointing me to this bug.

We'll fix it in the next PHPRunner update.
To make your pages working please do following:

  • open C:/Program Files/PHPRunner3.2/source/include/commonfunctions.php[/b] file


  • find this code snippet:

    ##if @f.strOrderBy##

    $LookupSQL.=" ORDER BY ##@f.pLookupObj.strTable ts##.##@f.strOrderBy ws##";

    endif


  • and add following code just after:

    ##if @f.pLookupObj.bDesc##

    $LookupSQL.=" DESC";

    endif




  • rebuild your pages.
J
 		Jkelleyus author 12/8/2006

Worked like a charm.
Thank you, Jane!