A little mathematics advise, please

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

A little mathematics advise, please

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> A little mathematics advise, please

Page: [1]


BeTheBall Posts: 6381 Joined: 6/21/2002 From: West Point Utah USA Status: offline	A little mathematics advise, please - 8/15/2003 9:06:14 If I am collecting data and later plan to do some arithmetic with that data, does the field need to be numeric? For example, I am gathering data via a form with two text boxes. Later, I will want to bring back results where (Textbox A - Text Box B) is greater than 5. The data in question is actually time of day, but am wondering if I code the fields in the db as time fields will I still be able to do the math?


bobby Posts: 11394 Joined: 8/15/1969 From: Seattle WA USA Status: offline	RE: A little mathematics advise, please - 8/15/2003 9:57:20 I think so... You should be able to convert data to an integer "on the fly" for doing calculations. Having it already in numeric format is easier (you don't have to convert to an integer each time you want to use the data) but I don't think it's necessary. Time is different, tho... you can perform math functions on time/date and ASP knows to roll minutes and hours at 60, days at 24 hours, etc. rather than rolling on multiples of 10... without converting the data. So in ASP, Date()+14 will be the same as 14 days from now, for example... < Message edited by bobby -- 8/15/2003 6:59:16 AM > _____________________________ If con is the opposite of pro, is Congress the opposite of progress? (in reply to BeTheBall)