This topic is locked

missing parameters in Report before SQL Events

2/13/2010 4:34:36 AM
PHPRunner General questions
A
acpan author

Some issues found with phpr 5.2

  1. only $strWhereClause is available and $strSQL, $strOrderBy are missing.
  2. $strWhereClause is not working as it append to the end. When

    your query string consist of ORDER BY or Group, it append the
    $strWhereClasue after it.
    => .... WHERE field_a = "b" Order by field_a AND field_d = "e"
    (In phpr 5.1, the whole before SQL event are totally missing,

    which cause unwanted data to be shown to user in the report)
    Thanks

    acpan

J
Jane 2/15/2010

Hi,
thank you. We'll fix this bug with WHERE statement in the next update.
I recommend you to use AfterTableInitevent to edit SQL query for the report. Check and edit WHERE clause in the $gsqlWhereExpr variable.