I hate when I miss things like this in the docs :O. Still wondering why there's no mapping of bigint to CF_SQL_BIGINT and why smallmoney maps to CF_SQL_DECIMAL and not CF_SQL_MONEY.
Anyway, thanks for the link. Very useful. Adrian -----Original Message----- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: 23 June 2008 16:42 To: CF-Talk Subject: Re: Column type to CF_SQL_TYPE map http://livedocs.adobe.com/coldfusion/8/htmldocs/Tags_p-q_18.html about 1/2 down the page. smalldatetime is cf_sql_timestamp (i only knew that one 'cuz it bit me in the ass a couple of weeks ago) :) On Mon, Jun 23, 2008 at 8:33 AM, Adrian Lynch <[EMAIL PROTECTED]> wrote: > 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:308095 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
