Login

    Register

This is to notify all, that we will be decommissioning http://riaforge.org/ ("Site") soon. This decision has been taken due to business reasons. If you are interested in reviewing or downloading any project or files available at Site, please do so, by April 16, 2019, 12 noon PST , as per license terms associated therewith. Past that, you will not be able to access the projects or files.Should you have any concerns/suggestions/query, feel free to Contact Us.
Managed Hosting

PROJECT CATEGORIES

 

Squidhead
Project Home Blog Forums Known Issues Screenshots External Project Link Contact Project

Squidhead Issue: Default Values for nullable Fields

Name: Default Values for nullable Fields
ID: 26
Project: Squidhead
Type: Bug
Area: Code
Severity: High
Status: Open
Related URL:
Creator: John Piotrowski
Created: 11/27/07 9:19 PM
Updated: 04/08/08 11:26 AM
Description: First off, i love the new changes to reduce the conditional logic around the cfprocparams and the fix to the precision and scale problem with decimals.

I did find a problem where the cfargument declarations of the method calls. I am including a snippet:
cfargument name="FIELDNAME" type="numeric" required="FALSE" default=""

but then

cfprocparam type="IN" cfsqltype="CF_SQL_INTEGER" variable="FIELDNAME" dbvarname="@FIELDNAME" value="#arguments.FIELDNAME#" maxlength="4" null="#arguments.FIELDNAME eq -9999#"

So if FIELDNAME is not provided it will not pass in Null like it should.
History: Created by JohnnyP10 (John Piotrowski) : 11/27/07 9:19 PM

Comment by dkonopka (Dave Konopka) : 04/08/08 11:26 AM
Seconding this one. Function calls bomb when no values are provided for numeric and date typed arguments. It would be great to have the argument default to the empty number (-9999) or date ({ts ...}) value.

To add a comment to this bug, please login using the link above.

This is to notify all, that we will be decommissioning http://riaforge.org/ ("Site") soon. This decision has been taken due to business reasons. If you are interested in reviewing or downloading any project or files available at Site, please do so, by April 16, 2019, 12 noon PST , as per license terms associated therewith. Past that, you will not be able to access the projects or files.Should you have any concerns/suggestions/query, feel free to Contact Us.