Hi -
Does anyone know the difference between CF_SQL_TIME and CF_SQL_TIMESTAMP
when using cfqueryparam on a table insert? We have a situation where we
use CF_SQL_TIME and its works fine in one environment, but we migrate to
another environment and in order to get the insert to work correctly I
have to use CF_SQL_TIMESTAMP. The coldfusion server version seem to be
same MX 6.1 except for one is enterprise version and one is not. Im not
certain about oracle database versions.
Heres the code in question:
<cfquery name="getTime" datasource=#DataSource#>
select sysdate now from dual
</cfquery>
<cfqueryparam cfsqltype="cf_sql_time" value="#DateAdd('n', 70,
getTime.now)#">
Thanks,
CC
x56927
----------------------------------------------------------------------------------------
This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit
written agreement or government initiative expressly permitting the use of
e-mail for such purpose.
----------------------------------------------------------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:223894
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
