2. PHPRunner General questions
  3. [SOLVED]  Query before print
This topic is locked
[SOLVED]

 Query before print

 		6/6/2012 9:43:22 AM
PHPRunner General questions
M
 maxcolo author

Hi,

sorry for my english but I am Italian user,

I have a chart called assortments that it is composed from:
id_assortimento

prod1

prod2

prod3

prod4

.....

prod70
Inside the fields there are some values (1 or 0), I would want that a filter was performed on the page of press (Print Page Before SQL Query) that made me see only the fields where 1 there are alone and it hid those with zero.

Is possible?
Sergey Kornilov admin 6/6/2012

Sure, you can do this. Here is the sample code:

$strWhereClause = whereAdd($strWhereClause, "fieldname=1");


Replace fieldname with the actual field name.
More info:

http://xlinesoft.com/phprunner/docs/modify_sql_query_on_the_fly.htm
M
 		maxcolo author 6/6/2012



Sure, you can do this. Here is the sample code:

$strWhereClause = whereAdd($strWhereClause, "fieldname=1");


Replace fieldname with the actual field name.
More info:

http://xlinesoft.com..._on_the_fly.htm


When the field is empty the page it is white....

example

$strWhereClause = whereAdd($strWhereClause, "prod1=1");

$strWhereClause = whereAdd($strWhereClause, "prod2=1");

$strWhereClause = whereAdd($strWhereClause, "prod3=1");

they have 1 and everything it is OK, when I add the quarter that I am empty from white page.
Example

$strWhereClause = whereAdd($strWhereClause, "prod1=1");

$strWhereClause = whereAdd($strWhereClause, "prod2=1");

$strWhereClause = whereAdd($strWhereClause, "prod3=1");

$strWhereClause = whereAdd($strWhereClause, "prod4=1");
Blank page!!!!!
Sergey Kornilov admin 6/6/2012

Try something like this.

$strWhereClause = whereAdd($strWhereClause, "prod1=1 and prod2=1 and prod3=1 and prod4=1");


If this doesn't help - post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.
M
 		maxcolo author 6/6/2012

Ok posted demo account and open ticket on support

Grazie