Anything unusual about the procedure like optional parameters?
(I know you said the input values are exactly the same, but ...) did you compare the debug information from cfquery and cfstoredproc? Just to verify everything truly is the same (values, data types, parameter position). Another long shot, does your procedure wrap the sql in a SET NOCOUNT ON/OFF? We typically do that in all our procedures to prevent extraneous record counts from inserts/updates from interfering with resultset processing in the calling program. -Leig ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:348915 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
