Question
Content expiration from web page
Hi, all - Dreamweaver 8.0.2, Win XP, using asp, vbscript, and
SQL database (and utilizing WebAssist's Super Suite).
I'm going to be developing a "clients only" area with asp pages connecting to a SQL database. As part of the project, I need to develop an administration area where our technical writing staff can add documents to the site (via an upload/web form) with a field on the form that lets them enter the date they want the content to expire. 'Expire' meaning the link to a particular file (this could be old release notes, product bulletins, etc.).no longer show up on the web page to the client once a given date is reached.
I'm only assuming that you would enter the expiration date in a column in the database table and then run a query that compares the column date to today's date and if the comparison yields some value, then the link is either displayed or it's not. Would that be fair logic?
I'm really not sure how to approach this - is this something that can be written in asp code or would this be more of a server function? If anyone has ever done this, I would be very grateful for any suggestions or 'best methods' in which to achieve this.
Thank you.
John
I'm going to be developing a "clients only" area with asp pages connecting to a SQL database. As part of the project, I need to develop an administration area where our technical writing staff can add documents to the site (via an upload/web form) with a field on the form that lets them enter the date they want the content to expire. 'Expire' meaning the link to a particular file (this could be old release notes, product bulletins, etc.).no longer show up on the web page to the client once a given date is reached.
I'm only assuming that you would enter the expiration date in a column in the database table and then run a query that compares the column date to today's date and if the comparison yields some value, then the link is either displayed or it's not. Would that be fair logic?
I'm really not sure how to approach this - is this something that can be written in asp code or would this be more of a server function? If anyone has ever done this, I would be very grateful for any suggestions or 'best methods' in which to achieve this.
Thank you.
John
AdChoices