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: