Featured post

c# - Usage of Server Side Controls in MVC Frame work -

i using asp.net 4.0 , mvc 2.0 web application. project requiremrnt have use server side control in application not possibl in noraml case. ideally want use adrotator control , datalist control. i saw few samples , references in codepleax mvc controllib howwver found less useful. can tell how utilize theese controls in asp.net application along mvc. note: please provide functionalities related adrotator , datalist controls not equivalent functionalities thanks in advace. mvc pages not use normal .net solution makes use of normal .net components impossible. a normal .net page use event driven solution call different methods service side mvc use actions , view completly different way handle things. also, mvc not use viewstate normal .net controlls require. found article discussing mixing of normal .net , mvc.

MySQL storing duration time - datatype? -


i need calculate time user spends on site. difference between logout time , login time give me "mr x spent 4 hours , 43 minutes online". store the4 hours , 43 minutes declared this: duration time not null

is valid or better way store this? need store in db because have other calculations need use + other use cases.

storing integer number of seconds best way go.

  • the update clean , simple - i.e. duration = duration + $increment
  • as tristram noted, there limitations using time field - e.g. "time values may range '-838:59:59' '838:59:59'"
  • the days/hours/minutes/seconds display formatting won't hardcoded.
  • the execution of other calculations surely clearer when working integer "number of seconds" field.

Comments

Popular posts from this blog

c# - Usage of Server Side Controls in MVC Frame work -

cocoa - Nesting arrays into NSDictionary object (Objective-C) -

ios - Very simple iPhone App crashes on UILabel settext -