This topic is locked

Deleting a data record

3/30/2008 12:09:57 AM
PHPRunner General questions
author

Ok here goes,
I am using the Events template in PHP runner 4.2.
I would like to either hide or delete a record from the listview after 5 days from the "From" date.
I have looked on the forum for some information without any luck.
Any hints on how I would do this would be highly appreciated!

A
alang 3/30/2008

One way would be to add a WHERE clause to the SQL comparing NOW with the "From" date. Either on the SQL tab directly or in the before SQL event code.