rgranger
|
| Posted: 08/08/2002, 6:55 PM |
|
to change the sql statement used for the default maintenanct form?
Also, am I just blind, I have looked in the user's guide and tutorial and don't see much documentation on events and what session vars are avalbie other than userid and group?
thanks
|
|
|
 |
Nicole
|
| Posted: 08/09/2002, 5:40 AM |
|
Hello,
you can access and modify the parts of the sql statement (SQL, Where, Order) in the Before Build Select Event. Here is sample code:
ASP
EventCaller.SQL = "custom sql"
EventCaller.Where = "custom where"
EventCaller.Order = "custom order by"
PHP
global $form_name;
$form_name->ds->SQL = "custom sql";
$form_name->ds->Where = "custom where";
$form_name->ds->Order = "custom order by";
To get the values of session variables UserID and GroupID use CCS functions
CCgetUserID() and CCGetGroupID(). All CCS functions are listed in the common file.
|
|
|
|
rgranger
|
| Posted: 08/09/2002, 2:22 PM |
|
reply to your post  Thanks that makes sense!
|
|
|
|
|
