Without seeing the rest of the form its hard to know.It sounds like the binding elements are firing off a little too quickly. One thing you could do is remove the argument type on the function in the cfc and then if both arguments are not numeric (use the isNumeric function) return a blank query (made using queryNew() ) so that the page does not break.
Thank you for the reply, Sam.
I did test changing the argument type to try and see what is being passed in... when only one argument is present, type numeric, everything works perfectly.
When I add a second numeric argument, I get an error that the first argument is not numeric.
If I change the argument type to a string to see what it's doing, I get an error about string invalid data ' '.
I'm still trying to debug it, but it has me stumped so far.
Oddly enough, and even though both arguments are numeric, I changed the arguments to strings,
and everything started working properly.
Why? Have no idea. But at least the binds are working properly now!
Cool. Embrace the beauty of a typeless language!