I just ran the following:
<cfquery name="qryCreateTable" datasource="temp">
CREATE TABLE myfile (
ID counter not NULL PRIMARY KEY,
PostDate datetime NULL ,
ModDate datetime NULL)
</cfquery>
<cfquery name="qryDateTest" datasource="temp">
insert into myfile (PostDate, ModDate)
values( <cfqueryparam value="#Now()#"
cfsqltype="cf_sql_timestamp">,
<cfqueryparam value="#DateFormat(Now(),"mm/dd/yyyy")#"
cfsqltype="cf_sql_Date">)
</cfquery>
<cfquery name="qryGetTest" datasource="temp">
select * from myfile
</cfquery>
<cfdump var="#qryGetTest#">
And got a 1 row dump, ModDate has the current Date with zeroes in the
time, and PostDate has the current date/time. All field configuration
done through SQL.
Matt Osbun
Web Developer
Health Systems, International
-----Original Message-----
From: Matt Robertson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 07, 2005 6:05 PM
To: CF-Talk
Subject: Re: Should we support Access?
Matt,
How exactly have you configured these date/time fields? The fields I
refer to were created via a cfquery statement, as in
<cfquery
username="#myDBUserName#"
password="#myDBPassword#"
datasource="#DSN#">
CREATE TABLE myfile (
ID COUNTER not NULL PRIMARY KEY,
PostDate datetime NULL ,
ModDate datetime NULL ,
);
</cfquery>
As such whatever happens in the field config has to come about via SQL
and can't be set from within Access (although I would be curious to
hear if thats what it takes).
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208953
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
