2. PHPRunner General questions
  3. PHPRunner 3.0 beta
This topic is locked

PHPRunner 3.0 beta

 		12/29/2005 11:52:44 PM
PHPRunner General questions
G
 grantmaker author

I am new to PHPRunner and PHP and have spent a couple days evaluating this program. I was about to give up when I saw the 3.0 beta version contained the table view options I was hoping for with the previous version.
I can't wait to play with the template editor although it looks like it could use a 'preview' mode.
My question is this: I have created several related tables that contain information about building widgets. I want to show 'open' and 'closed' job logs. A job is considered closed when the "Closed" date field contains a date. It is still open as long as the "Closed" date field is empty. Where would I plug this filter into the sql code in order to view just the open or just the closed jobs?
Secondly, is there a report function in the works where one could custom design reports (grouped, sorted, etc.) and either show on screen or print to printer?
Thanks and congrats for a great program.
G
 		grantmaker author 12/30/2005

I had one more post to add.
One last issue. When I added a new view of an existing table, I simply removed some of the viewable table row items and did a build. When I ftp'd the files, I got this message:
PHP error happened

Technical information

Error type 256

Error description Incorrect table name ', '

Error file include/dbconnection.php

Error line 26
Can anyone tell me what I did wrong?
Thanks,
Sergey Kornilov admin 12/30/2005

Hi,
you can create a view for your table in PHPRunner.

Then go to Edit SQL query tab and modify SQL this way:

select

...

from jobs

where Closed is not null



Then choose your original table and modify its SQL this way:

select

...

from jobs

where Closed is null


No, PHPRunner 3.0 doesn't create reports.
I wasn't able to reproduce this error. Could you please zip and send to support@xlinesoft.com the full set of generated PHP files along with your database creation script ? I'll find what's wrong running your pages on my test box.
G
 		grantmaker author 12/30/2005

Sergey,
Thanks for the quick response. I sent the code via my regular email. I noticed another post on 3.0 beta. Should we be posting here or somewhere else?
Thanks!