I have a stored proc in SQl Server 2000 with a variable @ID varchar(6) output
I call the procudure from Coldfusion as normal. <cfstoredproc procedure = "Child" dataSource = "#dsn#"> <cfprocparam type="Out" CFSQLType = "CF_SQL_VARCHAR" value="#url.ID#" null="no"> <cfprocresult name = "childInfo"> </cfstoredproc> the problem is if ID=12345A everything is fine. but if ID=12345 i get ZERO results,,, even tho 12345 exists the Procedure is solid inside SQL and it only occurs in the page. I feel SQL or CF is somehow converting my VARCHAR into an INT... Any help would be apreciated. -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 "The most important step is always the first one." ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239581 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54