Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

cf_sql_integer vs cf_sql_bigint vs cf_sql_int??

Participant ,
Feb 07, 2009 Feb 07, 2009
I have an ID (primary key) set as a BIGINT in SQL SERVER. I have a query with the following:

WHERE whateverid = <cfqueryparam cfsqltype="cf_sql_integer" value="#URL.id#">

I then got an invalid data type for it. I then tried:

WHERE whateverid = <cfqueryparam cfsqltype="cf_sql_bigint" value="#URL.id#">

I still got an invalid data type for it. i then tried:

WHERE whateverid = <cfqueryparam cfsqltype="cf_sql_int" value="#URL.id#">

and it worked.

The weird thing is cf_sql_int is not even listed as being accepted:
http://www.adobe.com/livedocs/coldfusion/5.0/CFML_Reference/Tags79.htm

Can some explain this to me.
TOPICS
Database access
5.5K
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Valorous Hero ,
Feb 07, 2009 Feb 07, 2009
> WHERE whateverid = <cfqueryparam cfsqltype="cf_sql_bigint" value="#URL.id#">

What is the value of #url.id#? I had no problems with either using CF8.

> The weird thing is cf_sql_int is not even listed as being accepted:

IIRC, when you pass in an invalid sql type CF just uses the default: cf_sql_char, which accepts just about anything. MS SQL probably does an implicit convert() to the right type and that is why it works.
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Participant ,
Feb 08, 2009 Feb 08, 2009
The number was like 200 something? I thought BIGINT covered the same as INT but just more.
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Valorous Hero ,
Feb 08, 2009 Feb 08, 2009
Yes, bigint can handle 64 bit and integer 32 bit. I had no problems with either using CF8 and the built in driver. Assuming your setup is the same, my guess would be the value as the most likely cause of the problem.

http://msdn.microsoft.com/en-us/library/ms378715(SQL.90).aspx
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
Feb 10, 2009 Feb 10, 2009
Try using TRIM function for #URL.id# as
#trim(URL.id)#
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Enthusiast ,
May 18, 2021 May 18, 2021
LATEST

FYI: "CF_SQL_INT" now throws an error with CF2016u17+, CF2018 and CF2021.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources