Print Page | Close Window

Results Time page

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=1598
Printed Date: 28 March 2026 at 11:14pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Results Time page
Posted By: Pegaso
Subject: Results Time page
Date Posted: 04 April 2003 at 4:37am

Hello,

i have a "little" question:

I will make a site with a classment but i need to insert times with hours, minutes,seconds and "secondcent" why can I make, access didnt support this time format. I can not utilize text-fields, why in the ASP page i must make the sums of the times.

And ASP support this time format?

It's a big problem, the time difference are very very little but if you sum the results of 20 stages at the end you have a "big" difference

Here you have an example without the secondcents

Pos.
Pilota / Vettura
Tempo
1
http://rally.efrance-pro.com/Pilota.asp?Fotopilota=Sainz Carlos&Fotoanno=2003 - Sainz Carlos ( http://rally.efrance-pro.com/Vettura2.asp?Fotoauto=Citroen Xsara WRC&Fotoanno=2003 - Citroen Xsara WRC )
04:32:14
2
http://rally.efrance-pro.com/Pilota.asp?Fotopilota=Burns Richard&Fotoanno=2003 - Burns Richard ( http://rally.efrance-pro.com/Vettura2.asp?Fotoauto=Peugeot 206 WRC&Fotoanno=2003 - Peugeot 206 WRC )
04:33:02
3
http://rally.efrance-pro.com/Pilota.asp?Fotopilota=Duval Francois&Fotoanno=2003 - Duval Francois ( http://rally.efrance-pro.com/Vettura2.asp?Fotoauto=Ford Focus WRC&Fotoanno=2003 - Ford Focus WRC )
04:34:00
4
http://rally.efrance-pro.com/Pilota.asp?Fotopilota=Mc Rae Colin&Fotoanno=2003 - Mc Rae Colin ( http://rally.efrance-pro.com/Vettura2.asp?Fotoauto=Citroen Xsara WRC&Fotoanno=2003 - Citroen Xsara WRC )
04:34:23
5
http://rally.efrance-pro.com/Pilota.asp?Fotopilota=Panizzi Gilles&Fotoanno=2003 - Panizzi Gilles ( http://rally.efrance-pro.com/Vettura2.asp?Fotoauto=Peugeot 206 WRC&Fotoanno=2003 - Peugeot 206 WRC )
04:34:55
6
http://rally.efrance-pro.com/Pilota.asp?Fotopilota=Martin Markko&Fotoanno=2003 - Martin Markko ( http://rally.efrance-pro.com/Vettura2.asp?Fotoauto=Ford Focus WRC&Fotoanno=2003 - Ford Focus WRC )
04:35:39
7
http://rally.efrance-pro.com/Pilota.asp?Fotopilota=Gardemeister Toni&Fotoanno=2003 - Gardemeister Toni ( http://rally.efrance-pro.com/Vettura2.asp?Fotoauto=Skoda Octavia WRC&Fotoanno=2003 - Skoda Octavia WRC )
04:37:27
8
http://rally.efrance-pro.com/Pilota.asp?Fotopilota=Makinen Tommi&Fotoanno=2003 - Makinen Tommi ( http://rally.efrance-pro.com/Vettura2.asp?Fotoauto=Subaru Impreza WRC&Fotoanno=2003 - Subaru Impreza WRC )
04:39:32

Ahh for the interested that's the classment of the rally of Turky

 



-------------



Replies:
Posted By: michael
Date Posted: 04 April 2003 at 9:47am
As far as I know MS Access only has an accuracy to a second. I am sure you can program a module to expand that but doubt it would be possible in a Data/Time field rather a text or number field. I have not found a native asp function that does it to the millisecond thus vb has a millisecond property of SPSystemTime so I found components that would do it for you. So the easiest thing for you would be to store it in a number or text field and do a manual calculation. Everything else (unless you use SQL) would get to complicated.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker


Posted By: Pegaso
Date Posted: 04 April 2003 at 9:53am

Do you mean Hour, minutes and seconds in a field and the milliseconds in an other field?

Example:

2:23:45.243
First field: 2:23:45
Second field: 243

Then if sum of second fields > 1000 then first field seconds + 1.

It's a possibility..... or a mental masturbation?



-------------


Posted By: Pegaso
Date Posted: 13 April 2003 at 3:06pm

I have found an ASP page that make that I need, you can see an example here:

http://www.patricksoft.fr/clt_epr_gen.asp?mode=0&meet=348&type=0&code=13&f=0&g=all&categ=0 - http://www.patricksoft.fr/clt_epr_gen.asp?mode=0&meet=348&type=0&code=13&f=0&g=all&categ=0

 



-------------



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net