Is there a definitive list of what CF SQL type goes with what column data type?
I have a few I'm not sure of (CF_SQL_???? below). Can anyone fill some of these in? These are all SQL 2005 data types. int CF_SQL_INTEGER nchar(10) CF_SQL_CHAR ntext CF_SQL_LONGVARCHAR numeric(18, 0) CF_SQL_NUMERIC nvarchar(50) CF_SQL_VARCHAR nvarchar(MAX) CF_SQL_???? real CF_SQL_REAL smalldatetime CF_SQL_???? smallint CF_SQL_SMALLINT smallmoney CF_SQL_???? sql_variant CF_SQL_???? text CF_SQL_LONGVARCHAR timestamp CF_SQL_TIMESTAMP tinyint CF_SQL_TINYINT uniqueidentifier CF_SQL_???? varbinary(50) CF_SQL_???? varbinary(MAX) CF_SQL_???? varchar(50) CF_SQL_VARCHAR varchar(MAX) CF_SQL_???? xml CF_SQL_???? bigint CF_SQL_BIGINT binary(50) CF_SQL_???? bit CF_SQL_BIT char(10) CF_SQL_CHAR datetime CF_SQL_DATE decimal(18, 0) CF_SQL_DECIMAL float CF_SQL_FLOAT image CF_SQL_???? money CF_SQL_MONEY I hope the formatting holds. I'd hazard a guess that for smallmoney you'd use CF_SQL_MONEY and the same for smalldatetime, CF_SQL_DATE. I've always used CF_SQL_LONGVARCHAR for text and ntext. Is this right? Thanks for any more insight. Adrian Lynch http://www.adrianlynch.co.uk/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307960 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
