Is the value of the erroring field "176" or "176[with trailing whitespace here]"?  This is probably what the issue is.

It's interesting that <cfargument> is passing it OK as a numeric, but <cfqueryparam> isn't seeing it as an int.  Not that numeric => integer necessarily, obviously.

What does isValid("integer", arguments.editionID) give you?

--

Adam

Also, what happens when you change the order to, for example, action=3&editionID=176&articleID=1756?

It occasionally seems to me that CF's development over the years has been in such a way that the left hand doesn't talk to the right hand, or even that the left hand didn't know there was a right hand to even talk to(*).  So similar things sometimes seem to work slightly differently (for example the difference in type validations between <cfpara> and <cfargument>).

So <cfargument> and <cfqueryparam> validations being different doesn't surprise me too much.

That said, is it the <cfqueryparam> validation failing, or is it the eventual DB call failing?  What's the exact error you were getting?

--

Adam

(*) talking hands.  Weird.

It appears that the problem lies with what ColdFusion treats as a numeric value.  The IsNumeric documentation says "Determines whether a string can be converted to a numeric value.".  The devil is in the details, "can be converted".  Javascript's parseFloat function will treat '135   ' as a numeric value because the string starts with a number.  Any non-numeric content after the number is ignored.  I suspect that CF's designers did the same so that CF would behave similary to Javascript.

You can work around this with some custom validation.   Here is a sample user defined function you could use.  I assume you are using Microsoft SQL Server.

<cffunction name="IsMsSqlInt" returntype="boolean" access="public" output="no" hint="Checks input to see if it is a valid MS SQL integer">
    <cfargument name="target" type="string" required="yes" hint="input to check" />

    <cfset var local=StructNew() />

    <cfset local.returnValue = false />

    <!--- does input match regular expression pattern for MS SQL integers, expression adapted from http://www.regular-expressions.info/floatingpoint.html  --->
    <cfif ReFind("^[-]{0,1}[0-9]{1,10}$", arguments.target) eq 1>
            <!--- is value within range of MS SQL INT datatype? http://msdn.microsoft.com/en-us/library/ms187745.aspx --->
            <cfif Val(arguments.target) gte -2147483648 and Val(arguments.target) lte 2147483647>
                <cfset local.returnValue = true />
            </cfif>   
    </cfif>

    <cfreturn local.returnValue />

</cffunction>

ColdFusion IsNumeric
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=func tions_in-k_37.html#4996076

Javascript parseFloat
https://developer.mozilla.org/en/Core_JavaScript_1.5_Reference/Global_ Functions/parseFloat