2. PHPRunner General questions
  3. EDIT SQL Query
This topic is locked

EDIT SQL Query

 		12/10/2005 1:42:07 PM
PHPRunner General questions
D
 defcon2000 author

Hello again,
I want to edit the Edit SQL qquesry box to be the following but just can't get it to work:
$gstrSQL = "select `reminder_id`, `reminderdate`, `reminder`, `autoclose`, `occurence`, `emailme`, `emailtoperson1`, `emailtoperson2`, `emailtoperson3`, `status`, `username` From `reminder` where username = '" . $_SESSION["UserID"] . "'";
Any ideas?
The above cutting works well when I edit the xxxx_function.php script but not when I edit te SQL in PHPRunner.
Pls help
S
 		sloftus 12/10/2005

Don't know if this helps but if you want the user to view/edit his data only you can do this by setting 'Users can see and edit their own data only' in the Security/Advanced tab.
D
 		defcon2000 author 12/11/2005

Yes, I know that can be done but I can't see any reason why my query is not working?
See if it can be fixed pls.
Sergey Kornilov admin 12/12/2005

You can not use $_SESSION["UserID"] when editing SQL query in PHPRunner.
Either modify $gstrSQL variable in include\..._variables.php file after project build or use Advanced security "Users can view their own data only" mode.
D
 		defcon2000 author 12/12/2005

Thanks. When is the next version coming out and what features should we expect?
Rgds,