This topic is locked

Dynamic Parameters To An Sql Query

5/7/2013 7:47:33 AM
PHPRunner General questions
pasquito author

Greetings to the development team PHPRunner
On many occasions I have seen the need to send dynamic parameters to an SQL query, which would take effect in the listing page or reports. A little of this functionality exists in the search panel functionality through filtering options, but these options only work on a single SQL SQL rather complex (nested select). What I mean is that PHPRunner have the functionality of a new window (like search panel), but this can configuar parameters (named) and criteria (equal, greater than, between, etc) will be replaced in the query in something like:
Select apenom, address, phone FROM Employees WHERE [criterion 1] and [Criteria2] ...
or perhaps a more complex SQL.
Is there any way to implement what was said above lines currently. If it is not possible at present, it could be considered in the next version of PHPRunner.
Sincerely.
Pasquito

Sergey Kornilov admin 5/7/2013

In many cases PHPRunner manual is a good place to start:

http://xlinesoft.com/phprunner/docs/modify_sql_query_on_the_fly.htm