Re: CF and Time

l Message - From: "Tangorre, Michael T." <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 19, 2001 4:44 PM Subject: RE: CF and Time Gotcha! :-) Sorry to be a pain... Been a long day. Thanks again, Mike -Original Message- From

Re: CF and Time

continuum (?)-> Tyler - Original Message - From: "Tangorre, Michael T." <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 19, 2001 4:44 PM Subject: RE: CF and Time Gotcha! :-) Sorry to be a pain... Been a long day. Thanks

Re: CF and Time AM and PM

Bryan Love wrote: > 00:00 AM is midnight - the very beginning of a new day. That would seem sensible to me as well. However, since the official format of a 12 hour clock goes back to before the number zero was invented it is not strictly defined as such. Some interesting reading can be found

RE: CF and Time AM and PM

] +---+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 2:59 PM To: CF-Talk Subject

Re: CF and Time AM and PM

Tangorre, Michael T. wrote: > Hello again, :-) > > I have a form in which a user enters a time, but I need to be able to > decipher between AM and PM.. Can they include this with their time? > What is the best way to do this, I will be storing this in a datetime field > in a SQL DB. The best

RE: CF and Time AM and PM

You have two options, here is the one I prefer... FORM PAGE - AM PM RECEIVING PAGE -- // convert to military time .. do whatever else you need to ... +---+ Bryan Love Macromedia

RE: CF and Time

] +---+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 1:36 PM To: CF-Talk Subject: RE: CF and Ti

RE: CF and Time

Gotcha! :-) Sorry to be a pain... Been a long day. Thanks again, Mike -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 4:46 PM To: CF-Talk Subject: RE: CF and Time right. that's what we're saying. use datetime a

RE: CF and Time

And the timestamp field does not contain a date/time value, it's more like a auto-incrementing number. > -Original Message- > From: Christopher Olive [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 19, 2001 4:46 PM > To: CF-Talk > Subject: RE: CF and Time &g

Re: CF and Time

Tangorre, Michael T. wrote: > Why can a SQL server Db table only contain one field of type timestamp? > I am not al that familiar with DBs yet. :-( If there ever was a time to get familiar with databases and datatypes it is now. It is important that you recognize what you can do in a db and w

RE: CF and Time

- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 4:36 PM To: CF-Talk Subject: RE: CF and Time Yeah I get an error when tyring to save the tale, it says timestamp can only be used in one column. :-( -Original Message- From: Christopher Oli

RE: CF and Time

Yeah I get an error when tyring to save the tale, it says timestamp can only be used in one column. :-( -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 4:28 PM To: CF-Talk Subject: RE: CF and Time that's strange. do you g

RE: CF and Time

ignore this.. I've fallen behind again.. as normal... -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 2:36 PM To: CF-Talk Subject: RE: CF and Time Not sure, but I think timestamp is a special field type used to identify

RE: CF and Time

ael T. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 2:00 PM To: CF-Talk Subject: RE: CF and Time Why can a SQL server Db table only contain one field of type timestamp? I am not al that familiar with DBs yet. :-( Mike -Original Message- From: Bryan Love [mailto:[EMAIL PROT

RE: CF and Time

er 19, 2001 4:21 PM To: CF-Talk Subject: RE: CF and Time H, But what if I want to send in 4 different times that are all being stored in the DB.. I am unable to use the datetime data type for all of the columns? -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Wedn

RE: CF and Time

d the default value will be a date/time stamp. When you want to update the time stamp just set the value to getDate() again. jon - Original Message - From: "Tangorre, Michael T." <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 19,

Re: CF and Time

value will be a date/time stamp. When you want to update the time stamp just set the value to getDate() again. jon - Original Message - From: "Tangorre, Michael T." <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 19, 2001 4:00 PM S

RE: CF and Time

Why can a SQL server Db table only contain one field of type timestamp? I am not al that familiar with DBs yet. :-( Mike -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 3:45 PM To: CF-Talk Subject: RE: CF and Time use timestamps

RE: CF and Time

use timestamps. Timestamps are more versatile that varchars since you can do math calculations with them. Depending on your gui layout you may also be better off storing a start time and a duration rather than a start and end time. Definitely use Timestamps - you'll thank yourself later when