I was about to mention that. I wasted hours on that just last week. :-)
Gilbert Midonnet -----Original Message----- From: Kevin Parker [mailto:tras...@internode.on.net] Sent: Tuesday, December 06, 2011 7:39 AM To: cf-talk Subject: RE: I can't count Solved - a stray space in the code will do it everytime :-) <cfqueryparam value=" #URL.s#" cfsqltype="CF_SQL_INTEGER" maxlength="6"> Should be <cfqueryparam value="#URL.s#" cfsqltype="CF_SQL_INTEGER" maxlength="6"> ++++++++++ Kevin Parker Advanced Imaging e: webmas...@advancedimaging.com.au w: www.advancedimaging.com.au m: 0418 815 527 ++++++++++ http://au.linkedin.com/in/krparker -----Original Message----- From: Kevin Parker [mailto:tras...@internode.on.net] Sent: Tuesday, 6 December 2011 23:15 To: cf-talk Subject: I can't count 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: webmas...@advancedimaging.com.au 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:348969 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm