You need to use the cfsqltype cf_sql_timestamp type for MSSQL, but you also
have to have datetime as your column type in MSSQL if you want the date and
time...instead of just smalldatetime, etc.
Tyler
_____
From: Matthew Walker [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 29, 2004 9:41 PM
To: CF-Talk
Subject: RE: cf_sql_date
Hmm fairly sure it's just the date. If you want the whole thing you need to
use cf_sql_timestamp. Am I wrong?
_____
From: Tyler Silcox [mailto:[EMAIL PROTECTED]
Sent: Friday, 30 July 2004 11:44 a.m.
To: CF-Talk
Subject: RE: cf_sql_date
With.
It passes in the output of #Now()#, which is the full date time stamp. But
what actually gets inserted into your DB depends on what datatype your
column is...
Tyler
_____
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 29, 2004 7:39 PM
To: CF-Talk
Subject: cf_sql_date
Will the following create a value with or without a 'time' portion?
<cfqueryparam cfsqltype="cf_sql_date" value="#Now()#">
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.726 / Virus Database: 481 - Release Date: 7/22/2004
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
