EasyCFM.COM ColdFusion Forums / Coding Help! / Inserting Pending Time

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: Inserting Pending Time

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

Mohsen
11-30-2002 @ 9:11 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
New Member
Posts: 8
Joined: Nov 2002

Hello:
I am designing the dynamic pages of a RealEstate by coldfusion , this has a specail law ,once an agent find a customer for a home ,he or she can pending it for 24 hours ,in this manner other agents can't suggest offer for that home in 24 hours .Would you please guide me to inserting the pending time
Sincerely Mohsen


Cold fusion

Webmaster
12-12-2002 @ 3:56 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Administrator
Posts: 4542
Joined: Jan 2002

The easiest way it to create a cell item in your database:

pending_date DateTime Field.

Then when they put in pending, you can do:

<cfset pending_date = DateAdd("h", +24, now())>

The "h" = Hour (You can do other option, view here : http://www.easycfm.com/cflanguage/index.cfm?tagID=127

Then when you insert it into the DB, do this:
#CreateODBCDate(pending_date)#

let me know if you need further help...

Thanks,
Pablo Varando
EasyCFM.COM, LLC.


Website Designed and Developed by Pablo Varando.