2. PHPRunner General questions
  3. [SOLVED]  Missing Records
This topic is locked
[SOLVED]

 Missing Records

 		1/30/2014 1:22:26 PM
PHPRunner General questions
C
 cjsaputo author

My data base listing and report is missing approx. 10 records from the data base. The records show in the "Results" tab when in PHP Runner, but the live screen is missing some of the records. These records are not deleted.
The app. is called Noble Photos Listing.
Sergey Kornilov admin 1/30/2014

Not enough info.
You may use events that hide some records dynamically or modify WHERE on the fly that eliminate those extra records. You may use one of Advanced Security options that hide records from certain users.
Start by printing SQL query on the page and running it manually against your database.
C
 		cjsaputo author 1/30/2014

Never mind. I uploaded what I had to the production environment and everything worked fine. Not sure why it is consistently missing records when I run from the PHP test site.
Thanks.



Not enough info.
You may use events that hide some records dynamically or modify WHERE on the fly that eliminate those extra records. You may use one of Advanced Security options that hide records from certain users.
Start by printing SQL query on the page and running it manually against your database.