I have an evaluation form and trying to work out the best way to add an elapsed time to the db for the eval.
In the reporting, I guess I just needta show a MIN(), MAX(), and AVG() on that field. But what's the best way to grab the time and insert something my DB functions can work with. And what datatype should the field be? Just a number, and insert total seconds into it? But maybe I wanna use minutes:seconds.... I've done this: User lands on the form page: <cfset SESSION.evalStartTime = Now()> User submits the eval: <cfset SESSION.evalEndTime = Now()> Calculate elapsed time for this eval <cfset SESSION.elapsedTime = SESSION.evalEndTime - SESSION.evalStartTime> Or should I Just use getTickCount() and insert that? Kinda mixed up on the best way... Thanks, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290431 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
