I need to modify Links to skip or delete a record if a particular date field (I added $db_enddate) has expired. Anyone know how to do this?

Thanks,

-Ryan

[This message has been edited by Ryan (edited February 14, 1999).]

Ryan,

You didn't say whether you were using Links 1 or 2. Here is something you can try using Links v1 and should be easily modified to use with Links v2. In site_html.pl:




I am not exactly sure if this works because I haven't tested it, but it looks right to me. If anyone sees any error in this, please speak up.

I hope this helps.


------------------
Bob Connors
bobsie@orphanage.com
www.orphanage.com/goodstuff/
goodstufflists.home.ml.org/




[This message has been edited by Bobsie (edited February 14, 1999).]

[This message has been edited by Bobsie (edited February 14, 1999).]

Thanks a lot Bob. I'm using one of the betas for Links 2. I'll play around with the code. I'd rather come up with something to delete expired entries in nhp-build.cgi. No sense in keeping them.

By the way, how do I delete a record?

&delete_records($rec{$db_enddate});

does not seem to work. I got an error message. I did add the require to db.pl in nph-build.cgi

Thanks again,

-Ryan

[This message has been edited by Ryan (edited February 14, 1999).]

 
The sub delete_records requires $rec{'ID'} as it searchs on the ID number. I wouldn't do this in nph-build.cgi though. I would put it in sub site_html_link, site_html.pl or site_html_templates.pl since that is where you discover the record has expired. You could include the call to that routine as part of the "else" portion of the code I gave you.

Regardless, I would be very careful with this deletion code being used while you are building pages. It could result in strange things happening.

It might be better just to open a text file and write the expired links to it and then, using that file, manually delete the links after the build is done. Or write a routine for nph-build.cgi that will delete expired records after the build is done (as the last thing it does or, check for expired links and delete them before the build starts. I just wouldn't do it during the build process.

As a matter of fact, the last thing I said is probably the best solution. If you could write the code to check for and delete any expired records before the build process begins, it would solve a lot of your problems doing what you want to do. You wouldn't need the mod I gave you at all.

I hope this gives you some ideas.



------------------
Bob Connors
bobsie@orphanage.com
www.orphanage.com/goodstuff/
goodstufflists.home.ml.org/