Try this. http://www.coldfusionjedi.com/index.cfm?mode=entry&entry=7D417738-DF64-B270-3056B422E2F6FCAB
Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com [email protected] www.trunkful.com On Oct 7, 2011, at 3:56 PM, Kris Sisk wrote: > > 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:348003 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
