2. PHPRunner General questions
  3. export selected problem
This topic is locked

export selected problem

 		8/24/2012 5:54:52 AM
PHPRunner General questions
C
 chanpeter88 author

When I set it in BeforeQueryExport event
$strWhereClause = "usernaem = '".$_SESSION['UserID']."'";
The exported selected function is not work. When I selected some records and enter 'export selected' button, current page records are exported.
If I don't set something in BeforeQueryExport event, the export selected is normal.
Sergey Kornilov admin 8/24/2012

'usernaem' or 'username'?
C
 		chanpeter88 author 8/27/2012

username. This is only example . this is not affect the result.
Sergey Kornilov admin 8/27/2012

What I'm saying is that if you didn't get field name right, like in your example, it may produce similar issues. Make sure your code is correct and produces correct SQL queries.
Print SQL queries on the web page and make sure they run as expected. More info on troubleshooting your code:

http://xlinesoft.com/phprunner/docs/debugging_tips.htm