tracker issue : CF-4203265

select a category, or use search below
(searches all categories and all time range)
Title:

[ANeff] Doc Bug for: cfqueryparam incorrect MSSQL types

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/Fixed

Reporter/Name(from Bugbase): Aaron Neff / ()

Created: 08/11/2018

Components: Documentation

Versions: 2018

Failure Type: Conflict With Docs

Found In Build/Fixed In Build: 0 / Documentation

Priority/Frequency: Normal / Very few users will encounter

Locale/System: / Platforms All

Vote Count: 0

Issue: The cfqueryparam doc lists these incorrect relationships:

ColdFusion | MSSQL
----------------------
CF_SQL_LONGVARBINARY | longvarbinary
CF_SQL_LONGNVARCHAR | nvarchar
CF_SQL_LONGVARCHAR | longvarchar

Those should be:

ColdFusion | MSSQL
----------------------
CF_SQL_LONGVARBINARY | image
CF_SQL_LONGNVARCHAR | ntext
CF_SQL_LONGVARCHAR | text

CF8's doc was correct. Issue was introduced in the CF9 and CF10 docs.

Related URL: https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-tags/tags-p-q/cfqueryparam.html

Related URL: https://docs.microsoft.com/en-us/sql/connect/jdbc/understanding-data-type-differences?view=sql-server-2017

Note: That MSSQL doc uses a '?view=sql-server-2017' URL parameter for version-specific docs. Slick huh? Adobe could take heed for version-specific CF docs.

Attachments:

Comments: