2. PHPRunner General questions
  3. Using Linked Lookup Wizards from different Tables
This topic is locked

Using Linked Lookup Wizards from different Tables

 		2/4/2007 1:43:01 PM
PHPRunner General questions
R
 run4sbc author

I'm trying out the linked lookup wizards on my registration page to set values in the login table.
I have a table set up for teams and team codes that will be used for the linked lookup wizards.
I just can't get it to work. I was wondering if anyone else had done something like this.
I'm using PHPRunner 3.1 build 212
R
 		run4sbc author 2/4/2007

This seems to be working on the edit/add pages but not on the Registration page, anyone have any ideas on what I need to change?
T
 		thesofa 2/4/2007

are you altering the global registration page, otr the add and edit page values in the visual editor?

I have just done a test project using 2 tables, one called staff to login, the other calles problems.

it worked fine.

Do me a sql dump of the database, empty the tables and I will tryit here for you.

Send me the project file too, of course.

HTH
R
 		run4sbc author 2/4/2007

http://www.trackmeetsonline.com/Database.zip
R
 		run4sbc author 2/4/2007

I have a Linked Lookup Wizard dropdown menu on the registration page that links to the Teams table. I want the data in it to set the Team Name and Team Code. Select the team name and the team code comes up. It does this in the admin add and edit user page for the protection table, but not on the registration page.
J
 		Jane 2/5/2007

Hi,
thank you for pointing me to this bug.

We'll fix it in the next PHPRunner update.
To make your pages working please open C:/Program Files/PHPRunner3.2/source/register.php file, find following line:

$includes="";

and replace it with this one:

$includes="";

$includes.="<script language=\"JavaScript\" src=\"include/jsfunctions.js\"></script>\r\n";

$includes.="<script language=\"JavaScript\">\r\n".

"var locale_dateformat = ".$locale_info["LOCALE_IDATE"].";\r\n".

"var locale_datedelimiter = \"".$locale_info["LOCALE_SDATE"]."\";\r\n".

"var bLoading=false;\r\n".

"var TEXT_PLEASE_SELECT='".addslashes(##message PLEASE_SELECT##)."';\r\n".

"</script>\r\n";
R
 		run4sbc author 2/5/2007

theres a incorrect ; somehwere in that code. I tried replacing some but it wouldnt fix it. I dont know which one is wrong.
R
 		run4sbc author 2/5/2007

nevermind, I copied the same code from the add.php and it worked.
Thanks!!
$includes="";

$includes.="<script language=\"JavaScript\" src=\"include/jsfunctions.js\"></script>\r\n";

$includes.="<script language=\"JavaScript\">\r\n".

"var locale_dateformat = ".$locale_info["LOCALE_IDATE"].";\r\n".

"var locale_datedelimiter = \"".$locale_info["LOCALE_SDATE"]."\";\r\n".

"var bLoading=false;\r\n".

"var TEXT_PLEASE_SELECT='".addslashes("Please select")."';\r\n".

"</script>\r\n";