cfsqltype cf_sql_tinyint Issue

2 replies
266 views
Translate

Is this a bug?

The cfsqltype cf_sql_smallint type doesn't work for any integer under 99, but the cfsqltype cf_sql_smallint does.

For example -

<cfset cookie.factId = 1>

<cfquery name="factMatchSelect" dbtype="query">
  SELECT
    id
  FROM
    factSelect
  WHERE id = <cfqueryparam value="#cookie.factId#" cfsqltype="cf_sql_tinyint">
</cfquery>

This topic is closed to new replies. Start a new post to keep the conversation going.

BKBKCorrect answer

Community Expert

I can imagine why you get an error with TinyInt, but not with SmallInt. I suspect that, under the hood, ColdFusion maps Shorts to SmallInt rather than to TinyInt.

That is quite likely a ColdFusion bug, which I have reported.

BKBK

Correct answer

Community Expert

I can imagine why you get an error with TinyInt, but not with SmallInt. I suspect that, under the hood, ColdFusion maps Shorts to SmallInt rather than to TinyInt.

That is quite likely a ColdFusion bug, which I have reported.

Translate

Christopher BowyerAuthor

Participant

I meant, The cfsqltype cf_sql_tinyint type doesn't work...

Translate

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.