I have this query in a remote accessible cfc: <cfquery datasource="staff" name="rq"> SELECT * FROM intervention WHERE studentId = <cfqueryparam value="#arguments.id#" cfsqltype="cf_sql_integer" > AND year=<cfqueryparam value="#arguments.year#" cfsqltype="cf_sql_integer"> </cfquery>
At issue is the second cfqueryparam. The arguments are passed in by a get request. When I pass in 2012 I get this error: [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. Trying to pass it in as an integer gets the same error. The odd thing is that any other value passed in works right, but 2012 throws an error every time. Any suggestions? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:348002 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
