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
