:[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
seconds or higher are rounded
up to the nearest minute.
So make sure you use datetime if you don't want to run into the year 2079
bug!
-Original Message-
From: Tyler Silcox [mailto:[EMAIL PROTECTED]
Sent: Friday, July 30, 2004 11:39 AM
To: CF-Talk
Subject: RE: cf_sql_date
Err...yea, you right.I
Additional question...I'm aware of the data validation done by
cfqueryparam, but does it also insulate the developer from the type of
datasource?For instance, if developing an application for both ODBC
datasources and native connections to DBMSs like Oracle and MS SQL, does
using
mycolumn =
Jim McAtee wrote:
Will the following create a value with or without a 'time' portion?
cfqueryparam cfsqltype=cf_sql_date value=#Now()#
Find out for yourself:
SELECT cfqueryparam cfsqltype=cf_sql_date value=#Now()#
FROM table
Jochem
[Todays Threads]
[This Message]
[Subscription]
[Fast
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:
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
Are StartDate and EndDate ODBC date objects?
If not, it may be that you're telling SQL server to expect ODBC dates, but
you're not them. (Whereas in your CFQUERY, SQL server is figuring out how
to handle that date data.)
What happens if you use value="#createODBCDate(createDate( month,day and
yes there is an issue - of a confusing name. Use the cf_sql_timestamp,
which is the one that actually corresponds to datetime and smalldatetime.
Mark
Mark Wimer, Bird Point Count Database
American Bird Conservancy, c/o
USGS-Patuxent Wildlife Research Center
12100 Beech Forest Road, Laurel, MD
I tried using ODBC date object and got the same error message. After doing
some search on the allaire forum I read that others were also having
problems. The suggestion was to use cf_sql_timestamp and it worked just fine
with that.
Thanks for your input.
Sebastian
on 12/7/00 2:41 PM, Hayes,
9 matches
Mail list logo
