2. PHPRunner General questions
  3. dependant dropdowns work in Visual editor, but not in generated pages
This topic is locked

dependant dropdowns work in Visual editor, but not in generated pages

 		11/21/2008 7:05:49 AM
PHPRunner General questions
T
 thesofa author

I have set up dependant dropdowns to select subject and teacher from a pair of views, the views are made in MySQL, not in PHPR, so they appear as tables in PHPR and not views. Thus I can use them for source tables for dropdowns

I have a 'Where' clause for each of the dropdowns.

Both the dropdowns work fine in the visual editor, but there is a message about the where clause not being applied, as it uses a session variable, this is created in the after successful login event, I have checked and the variable is populated with the correct vale from the login table.

When I build the pages, after login the Add page appears and the two dropdownd show 'Please Select' and no records.

The where clause reads as follows

"'year'=".$_SESSION["yg"]


What have I done wrong here?
J
 		Jane 11/21/2008

Hi,
It's hard to tell you what's wrong without seeing actual files.
Please publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.
T
 		thesofa author 11/21/2008

Hi,

It's hard to tell you what's wrong without seeing actual files.
Please publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.



tried to, all i get is"Error:Error details not available", after I have deleted all the other databases from the account.

I can email you the sql file and PHPR file if it will help?
T
 		thesofa author 11/21/2008

emailed to support....