This topic is locked

Documentation on New Events

10/16/2007 12:51:03 AM
PHPRunner General questions
G
giles author

Hi folks,
The more I use 4.1 the more I am impressed. Great work folks. And it keeps getting better with every release.
One question....
Where do I find documentation on how to use the newer event types? The older events come with some examples for inserting right into the events but I haven't been able to find anything for the newer ones. (I did download a Word document letting us know the new events exist but it does not contain examples.)
A case in point: The Before Query Event....

I've come across 2 ways of modifying/adding the WHERE phrase in the query but I'm not really sure how they work. So far I've found that:

  1. Can directly modify the strWhereClause
  2. Can use a AddWhere function to modify the WHERE clause.
    Searching through the forum trying to find out how these things are supposed to work is a bit time consuming. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=6520&image=1&table=forumtopics' class='bbc_emoticon' alt=':blink:' /> Also no idea what excellent features I may be missing out on...
    So..any documentation/examples anywhere?

Alexey admin 10/17/2007

Hi,
we'll update the events part of PHPRunner manual shortly.

The recommended way to modify SQL query is altering $strWhereClause variable.

You can use addWhere function for this.

$strWhereClause = whereAdd($strWhereClause,"user='Bob'");


Old codes that modify $strSQL variable would work too.

However that way doesn't support complex SQL queries with subqueries etc.