Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Results Time page
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Results Time page

 Post Reply Post Reply
Author
Pegaso View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 13 February 2003
Location: Switzerland
Status: Offline
Points: 138
Post Options Post Options   Thanks (0) Thanks(0)   Quote Pegaso Quote  Post ReplyReply Direct Link To This Post Topic: Results Time page
    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
Sainz Carlos (Citroen Xsara WRC)
04:32:14
2
Burns Richard (Peugeot 206 WRC)
04:33:02
3
Duval Francois (Ford Focus WRC)
04:34:00
4
Mc Rae Colin (Citroen Xsara WRC)
04:34:23
5
Panizzi Gilles (Peugeot 206 WRC)
04:34:55
6
Martin Markko (Ford Focus WRC)
04:35:39
7
Gardemeister Toni (Skoda Octavia WRC)
04:37:27
8
Makinen Tommi (Subaru Impreza WRC)
04:39:32

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

 

Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Pegaso View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 13 February 2003
Location: Switzerland
Status: Offline
Points: 138
Post Options Post Options   Thanks (0) Thanks(0)   Quote Pegaso Quote  Post ReplyReply Direct Link To This Post 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?

Back to Top
Pegaso View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 13 February 2003
Location: Switzerland
Status: Offline
Points: 138
Post Options Post Options   Thanks (0) Thanks(0)   Quote Pegaso Quote  Post ReplyReply Direct Link To This Post 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

 

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.