freelanceprogrammers.org Forum Index » Cold Fusion

View previous topic :: View next topic

timed event in CF

rgpg_99 Posted: Sun Oct 23, 2005 11:42 pm

Joined: 01 Apr 2005

Posts: 16

timed event in CF

Hi all,

I`m working on an application form that has to be available only through
certain dates. I have a few fields where a user with admin priviledges can
enter a date and a time (hour:min:sec) for the application to become
available and unavailable (thus closing the application period). Then there
is a field called "status" with the options "open" or "close". The content
of that field should be changed on the date specified in the database.

My question is: what does ColdFusion offer in the way of triggering events?
For instance, I`d like the date/time that is already entered into the
database to be checked regularly and executed automatically by the CF
server. How can that be set up?

Thanks in advance,

Roberto Perez
rgpg@...

himanshu_mps Posted: Mon Oct 24, 2005 5:15 am

Joined: 24 Oct 2005

Posts: 1

timed event in CF

Hello Roberto,

You can write a query to check the current date and the date that you have saved in the database. Based on the result of the query(the recordcount), you can decide to make the application up or down.

Hope that helps.

Regards,
HimanshuRoberto Perez <rgpg@...> wrote:
Hi all,I`m working on an application form that has to be available only through certain dates. I have a few fields where a user with admin priviledges can enter a date and a time (hour:min:sec) for the application to become available and unavailable (thus closing the application period). Then there is a field called "status" with the options "open" or "close". The content of that field should be changed on the date specified in the database.My question is: what does ColdFusion offer in the way of triggering events? For instance, I`d like the date/time that is already entered into the database to be checked regularly and executed automatically by the CF server. How can that be set up?Thanks in advance,Roberto Perezrgpg@...

Himanshu Gupta
C-22, Hari Marg
Malviya Nagar
Jaipur-302017
Phone : 0141-2524304

E-mail : himanshu_mps@...
himanshu_mps@...

Yahoo! FareChase - Search multiple travel sites in one click.

rgpg_99 Posted: Mon Oct 24, 2005 5:50 am

Joined: 01 Apr 2005

Posts: 16

timed event in CF

At 05:15 PM 10/23/2005, HIMANSHU GUPTA wrote:
>
>You can write a query to check the current date and the date that you have
>saved in the database. Based on the result of the query(the recordcount),
>you can decide to make the application up or down.
>

Thanks for the answer. Yes, that`s what I have so far. Each time a user
goes to the main page, a query is performed to see if the "status" field is
"open" or "closed", and based on that either the application or a "period
not open" message are displayed.

What I`m trying to achieve, instead of an administrator changing the status
manually from "closed" to "open" and viceversa, is the system (e.g., CF) to
trigger the change automatically based on the date and time stated in the
database (like an automated task).

Thanks for any ideas you may have.

Roberto Perez
rgpg@...

Skulbite@... Posted: Mon Oct 24, 2005 6:57 pm

Joined: 23 Oct 2005

Posts: 2

timed event in CF

Hi Roberto,

If you have access to CFSCHEDULE on the server, it would be a good plan to
use it in this instance. You can schedule a page to be run that will make
the updates for you.

Richard.

At 12:58 PM 10/24/2005 +0000, you wrote:
> Date: Sun, 23 Oct 2005 20:50:50 -0400
> From: Roberto Perez <rgpg@...>
>Subject: Re: timed event in CF
>
>At 05:15 PM 10/23/2005, HIMANSHU GUPTA wrote:
> >
> >You can write a query to check the current date and the date that you have
> >saved in the database. Based on the result of the query(the recordcount),
> >you can decide to make the application up or down.
> >
>
>
>Thanks for the answer. Yes, that`s what I have so far. Each time a user
>goes to the main page, a query is performed to see if the "status" field is
>"open" or "closed", and based on that either the application or a "period
>not open" message are displayed.
>
>What I`m trying to achieve, instead of an administrator changing the status
>manually from "closed" to "open" and viceversa, is the system (e.g., CF) to
>trigger the change automatically based on the date and time stated in the
>database (like an automated task).
>
>Thanks for any ideas you may have.
>
>
>Roberto Perez
>rgpg@...

freelanceprogrammers.org Forum Index » Cold Fusion

All times are GMT
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Freelace Website Designer - Customer web design and software building.
Booking Calendar - reservation calendar script
Land Surveying - total station instruments and equipments
China Wholesale - Electronics Products
Character Studio - Tutorials and Help