Billy,
Thanks for your reply. I got it working the way I need now. I was trying to
use the formatting functions in CF to display the data and none of them
allowed for milliseconds. So I just altered the SQL using CONVERT and I am
displaying that. It really works. Guess it is just too early on Monday to
attempt something like this.
Thanks again,
Dolan
----- Original Message -----
From: Billy Cravens <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Monday, August 27, 2001 8:48 AM
Subject: RE: Recording milliseconds
> Since you are just storing the current timestamp, why are you generating
> it in CF? This is a perfect example of a situation where you should let
> your database do the work.
>
> Instead of
> INSERT INTO someTable (myDate)
> VALUES('#Now()#')
>
> Do
> INSERT INTO someTable (myDate)
> VALUES(GetDate())
>
>
> ---
> Billy Cravens
> Web Development, EDS
> [EMAIL PROTECTED]
>
>
> -----Original Message-----
> From: Dolan Trout [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 27, 2001 8:19 AM
> To: CF-Talk
> Subject: Re: Recording milliseconds
>
>
> Mark,
>
> Yes. I don't think the problem is with the SQL. I can't seem to find
> any function or method in CF that will allow me to display the
> milliseconds.
>
> Thanks for the rapid response.
>
> ----- Original Message -----
> From: Mark Stewart <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Sent: Monday, August 27, 2001 8:11 AM
> Subject: RE: Recording milliseconds
>
>
> > Dolan,
> >
> > Have you used the getdate() SQL Server function? I believe that it
> > stores milliseconds as well.
> >
> > Mark
> >
> > -----Original Message-----
> > From: Dolan Trout [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, August 27, 2001 8:44 AM
> > To: CF-Talk
> > Subject: Recording milliseconds
> >
> >
> > I currently have an Insert on a cfm page that stores a datetime in an
> > SQL 7 database by using the Now() function. The problem is that I
> > need to record
> > milliseconds and the Now() function does not pass milliseconds. SQL 7
> > (according to book online) will only store what is passed. If any one
> > has
> > some insight on this, I would greatly appciate it.
> >
> > Thanks,
> > Dolan Trout
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
