tracker issue : CF-3150840

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

cfProcParam's MaxLength does absolutely nothing

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Andrew Hales / Andrew Hales (andrew.hales)

Created: 03/27/2012

Components: Database

Versions: 9.0.1

Failure Type: Non Functioning

Found In Build/Fixed In Build: 9.0.1 /

Priority/Frequency: Critical / All users will encounter

Locale/System: English / Win 2008 Server R2 64 bit

Vote Count: 0

Problem Description: Maxlength does not generate and error when the value of a cfprocparam exceeds the length specified in maxlength.

Steps to Reproduce: Specify a maxlength for a cfProcParam with type="in" and cfsqltype="CF_SQL_VARCHAR".  Set this maxlength to a value above 0 and then enter for the value a string greater than that length.

Actual Result: Nothing happens

Expected Result: An error similar to cfqueryparam's maxlength

Any Workarounds: None to my knowledge

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3150840

External Customer Info:
External Company:  
External Customer Name: andrew.hales
External Customer Email:  
External Test Config: My Hardware and Environment details: 

Server CF9.01 running on a Win 2008 Server R2 64 bit

Development machine builds to the server using eclipse and ant.  The development machine is Windows 7 using eclipse 3.6.2.  Our database server is also a Win 2008 R2 64 bit running SQL Server 2008.

Attachments:

Comments:

When searching for this error I also found this: http://www.elliottsprehn.com/cfbugs/bugs/77309
Comment by External U.
19881 | March 27, 2012 09:49:55 AM GMT
This issue is fixed in ColdFusion 10.
Comment by Nimit S.
19882 | October 29, 2013 06:29:05 AM GMT