This is one of the few problems I haven't had with using cfqueryparam
with Access.
With a two-field Access table- an Autonumbering ID field as PK and
TheDate as a Date field:
<cfquery name="qryDateTest" datasource="temp">
insert into TestTable (TheDate)
VALUES (<cfqueryparam value="#DateFormat(Now(),"mm/dd/yyyy")#"
cfsqltype="cf_sql_date">)
</cfquery>
And
<cfquery name="qryDateTest" datasource="temp">
insert into TestTable (TheDate)
VALUES (<cfqueryparam value="#Now()#"
cfsqltype="cf_sql_timestamp">)
</cfquery>
Both inserted correctly and
<cfquery name="qryDateTest" datasource="temp">
update TestTable set TheDate = <cfqueryparam value="#Now()#"
cfsqltype="cf_sql_timestamp">
where id=1
</cfquery>
Updated correctly.
Matt Osbun
Web Developer
Health Systems, International
-----Original Message-----
From: Matt Robertson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 07, 2005 2:12 PM
To: CF-Talk
Subject: Re: Should we support Access?
Access will explode on contact with ANY date field when you try to use
cfqueryparam on it. None of the cfsqltypes work so you have to write
your code with this in mind and protect yourself in other ways.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208872
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=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
