This topic is locked

Search SQL Error when a field from another table is present

9/16/2006 8:03:52 PM
PHPRunner General questions
M
MikeB941 author

Hello All:
First, thank you all for such helpful posts here... As a new PHPRUNNER user these have been invaluable.
I just wanted to touch bases on a subject that has been addressed here before but I'm hoping for an easier answer (possibly in 3.1)?
Whenever additional fields are brought in via the SQL statement that do not belong to the base table, PHPRUNNER 3.0 Build 119 does not qualify these correctly in the GetFullFieldName function of commonfunctions.php file in the include output folder as documented in:
http://www.xlinesoft.com/articles/search_s...okup_values.htm
Basically everything gets qualified with the base table name even though the field came from another table. This results in a SQL error anytime this field is reference in a search or advanced searched.
Having to MANUALLY go in and update the GetFullFieldName function after every build with the correct table qualification names is hard to remember and error prone.
Is there any work around or fix in plan so that the GetFullFieldName will generate the CORRECT table name qualifications in these cases?
Many thanks.
Take Care... Mike.

M
MikeB941 author 9/18/2006

Hello Again:
Just regenerated code under PHPRUNNER 3.1 and noticed that this problem still exists.
Thanks again for any help.
Take Care... Mike.

Alexey admin 9/19/2006

Mike,
thank you for your feedback.

We'll make PHPRunner recognize the tables from which the fields come properly in the version of PHPRunner coming after 3.1
There is no fix or workaround available yet.