Automatically remove record?

[woodywyatt]

Can anyone tell me if its possible to automatically remove (not delete) a
record from database after a certain date has passed?
I want to use a feature like this to stop clients advertisements being shown
on a results page after a renewal date has passed
Many thanks
Gary

[Drew]

Yes, depending on the database server you are using... you could use
triggers, but probably the best way would be to modify your query for the
ads so that it only shows ads that aren't past their renewal date, here is
an example,

SELECT *
FROM Ads
WHERE AdRenewDate > GetDate()

The above code will work with SQL Server, not sure about other database
systems...

HTH,
Drew


"woodywyatt" <woodywyatt@fuerteventura.com> wrote in message
news:d365hh$6ei$1@forums.macromedia.com...

> Can anyone tell me if its possible to automatically remove (not delete) a
> record from database after a certain date has passed?
> I want to use a feature like this to stop clients advertisements being
> shown
> on a results page after a renewal date has passed
> Many thanks
> Gary
>
>

[woodywyatt]

I think I've got myself even more confused here.
Okay, I'll explain what I need to do..
I have a form where users can fill in their details and upload an image to a
database to be displayed as an advertisement. I would also like to somehow
insert today's date from this form at the same time. Then after one year,
from this date automatically remove (not delete) the record from database.
Can you point me in the right direction?
I'm using ASP running on Access (DSN connection)
Thanks
Gary

Thanks
"Drew" <drew.laing@NOswvtc.dmhmrsas.virginia.SPMgov> wrote in message
news:d369oq$cuk$1@forums.macromedia.com...

> Yes, depending on the database server you are using... you could use
> triggers, but probably the best way would be to modify your query for the
> ads so that it only shows ads that aren't past their renewal date, here is
> an example,
>
> SELECT *
> FROM Ads
> WHERE AdRenewDate > GetDate()
>
> The above code will work with SQL Server, not sure about other database
> systems...
>
> HTH,
> Drew
>
>
> "woodywyatt" <woodywyatt@fuerteventura.com> wrote in message
> news:d365hh$6ei$1@forums.macromedia.com...

> > Can anyone tell me if its possible to automatically remove (not delete)

a

> > record from database after a certain date has passed?
> > I want to use a feature like this to stop clients advertisements being
> > shown
> > on a results page after a renewal date has passed
> > Many thanks
> > Gary
> >
> >

>
>

[Lionstone]

Remove and delete are the same thing. To only show records less than a year
old, then do what the last post told you to, filter by date where dateField

>= DateAdd("yyyy",-1,Date())

--
-------------------------------------------------------------------
You must SHOW YOURSELF to e-mail me. No cowards allowed!




"woodywyatt" <woodywyatt@fuerteventura.com> wrote in message
news:d36qn0$6mt$1@forums.macromedia.com...

> I think I've got myself even more confused here.
> Okay, I'll explain what I need to do..
> I have a form where users can fill in their details and upload an image to

a

> database to be displayed as an advertisement. I would also like to somehow
> insert today's date from this form at the same time. Then after one year,
> from this date automatically remove (not delete) the record from database.
> Can you point me in the right direction?
> I'm using ASP running on Access (DSN connection)
> Thanks
> Gary
>
> Thanks
> "Drew" <drew.laing@NOswvtc.dmhmrsas.virginia.SPMgov> wrote in message
> news:d369oq$cuk$1@forums.macromedia.com...

> > Yes, depending on the database server you are using... you could use
> > triggers, but probably the best way would be to modify your query for

the

> > ads so that it only shows ads that aren't past their renewal date, here

is

> > an example,
> >
> > SELECT *
> > FROM Ads
> > WHERE AdRenewDate > GetDate()
> >
> > The above code will work with SQL Server, not sure about other database
> > systems...
> >
> > HTH,
> > Drew
> >
> >
> > "woodywyatt" <woodywyatt@fuerteventura.com> wrote in message
> > news:d365hh$6ei$1@forums.macromedia.com...

> > > Can anyone tell me if its possible to automatically remove (not

delete)

> a

> > > record from database after a certain date has passed?
> > > I want to use a feature like this to stop clients advertisements being
> > > shown
> > > on a results page after a renewal date has passed
> > > Many thanks
> > > Gary
> > >
> > >

> >
> >

>
>

[woodywyatt]

Thanks for the swift reply
Excuse my ignorance but can you clarify what the correct SQL would be?
I've tried using this -
SELECT *
FROM upload
WHERE Date >= 'DateAdd("yyyy",-1,Date())'
But this doesn't seem to work.
Do I need to enter anything in the variables fields?


"Lionstone" <HIDELionstoneHIDE@HIDEhush.com> wrote in message
news:d36u40$b3k$1@forums.macromedia.com...

> Remove and delete are the same thing. To only show records less than a

year

> old, then do what the last post told you to, filter by date where

dateField

> >= DateAdd("yyyy",-1,Date())

> --
> -------------------------------------------------------------------
> You must SHOW YOURSELF to e-mail me. No cowards allowed!
>
>
>
>
> "woodywyatt" <woodywyatt@fuerteventura.com> wrote in message
> news:d36qn0$6mt$1@forums.macromedia.com...

> > I think I've got myself even more confused here.
> > Okay, I'll explain what I need to do..
> > I have a form where users can fill in their details and upload an image

to

> a

> > database to be displayed as an advertisement. I would also like to

somehow

> > insert today's date from this form at the same time. Then after one

year,

> > from this date automatically remove (not delete) the record from

database.

> > Can you point me in the right direction?
> > I'm using ASP running on Access (DSN connection)
> > Thanks
> > Gary
> >
> > Thanks
> > "Drew" <drew.laing@NOswvtc.dmhmrsas.virginia.SPMgov> wrote in message
> > news:d369oq$cuk$1@forums.macromedia.com...

> > > Yes, depending on the database server you are using... you could use
> > > triggers, but probably the best way would be to modify your query for

> the

> > > ads so that it only shows ads that aren't past their renewal date,

here

> is

> > > an example,
> > >
> > > SELECT *
> > > FROM Ads
> > > WHERE AdRenewDate > GetDate()
> > >
> > > The above code will work with SQL Server, not sure about other

database

> > > systems...
> > >
> > > HTH,
> > > Drew
> > >
> > >
> > > "woodywyatt" <woodywyatt@fuerteventura.com> wrote in message
> > > news:d365hh$6ei$1@forums.macromedia.com...
> > > > Can anyone tell me if its possible to automatically remove (not

> delete)

> > a

> > > > record from database after a certain date has passed?
> > > > I want to use a feature like this to stop clients advertisements

being

> > > > shown
> > > > on a results page after a renewal date has passed
> > > > Many thanks
> > > > Gary
> > > >
> > > >
> > >
> > >

> >
> >

>
>

[Lionstone]

No quotes around the DateAdd function.

--
-------------------------------------------------------------------
You must SHOW YOURSELF to e-mail me. No cowards allowed!




"woodywyatt" <woodywyatt@fuerteventura.com> wrote in message
news:d36vpv$d68$1@forums.macromedia.com...

> Thanks for the swift reply
> Excuse my ignorance but can you clarify what the correct SQL would be?
> I've tried using this -
> SELECT *
> FROM upload
> WHERE Date >= 'DateAdd("yyyy",-1,Date())'
> But this doesn't seem to work.
> Do I need to enter anything in the variables fields?
>
>
> "Lionstone" <HIDELionstoneHIDE@HIDEhush.com> wrote in message
> news:d36u40$b3k$1@forums.macromedia.com...

> > Remove and delete are the same thing. To only show records less than a

> year

> > old, then do what the last post told you to, filter by date where

> dateField

> > >= DateAdd("yyyy",-1,Date())

> > --
> > -------------------------------------------------------------------
> > You must SHOW YOURSELF to e-mail me. No cowards allowed!
> >
> >
> >
> >
> > "woodywyatt" <woodywyatt@fuerteventura.com> wrote in message
> > news:d36qn0$6mt$1@forums.macromedia.com...

> > > I think I've got myself even more confused here.
> > > Okay, I'll explain what I need to do..
> > > I have a form where users can fill in their details and upload an

image

> to

> > a

> > > database to be displayed as an advertisement. I would also like to

> somehow

> > > insert today's date from this form at the same time. Then after one

> year,

> > > from this date automatically remove (not delete) the record from

> database.

> > > Can you point me in the right direction?
> > > I'm using ASP running on Access (DSN connection)
> > > Thanks
> > > Gary
> > >
> > > Thanks
> > > "Drew" <drew.laing@NOswvtc.dmhmrsas.virginia.SPMgov> wrote in message
> > > news:d369oq$cuk$1@forums.macromedia.com...
> > > > Yes, depending on the database server you are using... you could use
> > > > triggers, but probably the best way would be to modify your query

for

> > the

> > > > ads so that it only shows ads that aren't past their renewal date,

> here

> > is

> > > > an example,
> > > >
> > > > SELECT *
> > > > FROM Ads
> > > > WHERE AdRenewDate > GetDate()
> > > >
> > > > The above code will work with SQL Server, not sure about other

> database

> > > > systems...
> > > >
> > > > HTH,
> > > > Drew
> > > >
> > > >
> > > > "woodywyatt" <woodywyatt@fuerteventura.com> wrote in message
> > > > news:d365hh$6ei$1@forums.macromedia.com...
> > > > > Can anyone tell me if its possible to automatically remove (not

> > delete)

> > > a
> > > > > record from database after a certain date has passed?
> > > > > I want to use a feature like this to stop clients advertisements

> being

> > > > > shown
> > > > > on a results page after a renewal date has passed
> > > > > Many thanks
> > > > > Gary
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >

> >
> >

>
>