I'm testing a value passed on a URL to check that it's an integer and no longer than 6 characters but get the error below. I suspect the question is that if I'm do a cfqueryparm for an integer then do I need to test the length at all but if so then why is 380001 more than 6 characters long.
"The cause of this output exception was that: coldfusion.tagext.sql.QueryParamTag$InvalidDataException: Invalid data value 380001 exceeds maxlength setting 6.." Thank you! ++++++++++ Kevin Parker Advanced Imaging e: [email protected] w: www.advancedimaging.com.au m: 0418 815 527 ++++++++++ http://au.linkedin.com/in/krparker ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348967 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
