This content has been marked as final.
Show 2 replies
-
1. Re: Content expiration from web page
Newsgroup_User Mar 18, 2007 4:06 PM (in response to BurritoVictim)On 18 Mar 2007 in macromedia.dreamweaver.appdev, BurritoVictim wrote:
> 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?
That would 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 ?
You'd write it in the SQL for the query:
SELECT field1, field2 FROM myTable WHERE expirationDate > GETDATE()
The GETDATE() function assumes that you're using Microsoft SQL Server;
you specified only "SQL", and that's the query language that almost all
databases use.
--
Joe Makowiec
http://makowiec.net/
Email: http://makowiec.net/email.php -
2. Re: Content expiration from web page
BurritoVictim Mar 18, 2007 4:50 PM (in response to BurritoVictim)Joe, thanks for your quick reply - yes, you are correct SQL meaning Microsoft SQL Server (thanks for the note, I'll be sure to be more specific next time).
Okay, this makes sense to me - for the web forms we currently use for our web visitors to register for webinars, request information, etc. I always include a column in the table named "dateSubmitted" that uses the (getdate()) function while saving to the database.
I'll give it a whirl - thank you, Joe!!
John


