Inserting Time to a SQL Database

[webgirljudi]

I'm builidng a program that requires me to record the time of day that a
department physcially receives a document and then when it leaves the
department. I also need to write a report that would subtract the report
ultimately saying that this document was in this department for 45 minutes or
10 hours. So my insert screen needs to be able to accept a manual entry of
time. I can't find a data type that seems to support this. I keep getting
errors. What am I missing? I'm using vbscript and a SQL server.

[CarlGrint]

In your Date/Time field in your SQL table you can use the default of Getdate()
which will stamp with the Date and Time that record is created.
When you want to update, this will not work, but you can use Now() in a hidden
field on the ASP page to insert the Date and Time to a field in your DB.

Originally posted by: webgirljudi
I'm builidng a program that requires me to record the time of day that a
department physcially receives a document and then when it leaves the
department. I also need to write a report that would subtract the report
ultimately saying that this document was in this department for 45 minutes or
10 hours. So my insert screen needs to be able to accept a manual entry of
time. I can't find a data type that seems to support this. I keep getting
errors. What am I missing? I'm using vbscript and a SQL server.

[webgirljudi]

The getdate() won't work - it's a manual entry. If I received physcial paper
on my desk at 8:00 and don't get to work on it until 10:00. When I enter my
time into this app I need to note both the 8:00 receive time the 10:00 start
time and the say 10:30 finish time. The folks using this program may not enter
the data until they are finished or may record it on paper and transfer it to
the program at the end ot the day. Therefore, I need 3 date/time stamps that
are manual. Does this make sense?

[CarlGrint]

Then all you need are the three columns in your database, set to Date/Time
format, then add in fields to your form to take the Times, giving the
approparate titles to ensure your user enters the Time in the correct field.

Originally posted by: webgirljudi
The getdate() won't work - it's a manual entry. If I received physcial paper
on my desk at 8:00 and don't get to work on it until 10:00. When I enter my
time into this app I need to note both the 8:00 receive time the 10:00 start
time and the say 10:30 finish time. The folks using this program may not enter
the data until they are finished or may record it on paper and transfer it to
the program at the end ot the day. Therefore, I need 3 date/time stamps that
are manual. Does this make sense?

[webgirljudi]

makes sense, but forgive me, how do I ensure they enter it correctly? Does dreamweaver have an error trapping thing I can add to these fields?

[CarlGrint]

You want to use the Yaromat form checker extension, that gives you the option
to ensure a Time is entered, although as with all it is Javascript based, so
you need to ensure Javascript is on.

Alteratively you can write an ASP checker which ensures the form data is
correct before entering into db.

[url]http://www.yaromat.com/dw/?ex=Check%20Form%20MX[/url]

Originally posted by: webgirljudi
makes sense, but forgive me, how do I ensure they enter it correctly? Does
dreamweaver have an error trapping thing I can add to these fields?

[webgirljudi]

Thank you, thank you!!

[webgirljudi]

i still must be missing something. I'm still getting the same error.

Incorrect syntax near ':'

it won't take the colon. I'm using an internal SQL server with the datetime type, 8 as the length

[CarlGrint]

It is possible that the database expects 18:03:10 and you are feeding 18:03 so
this may be a problem.

Depending on your requirements, you could always do away with the Date/Time
format, and use a varchar field to store the time.

It depends if you wish to carry out calculation on the Times saved.

Originally posted by: webgirljudi
i still must be missing something. I'm still getting the same error.
Incorrect syntax near ':' it won't take the colon. I'm using an internal
SQL server with the datetime type, 8 as the length