Hi,

At March 27, 2005, 04:03, rfrieband wrote:

> I have a stored procedure that for some reason is only returning the
> 1st row of the result set to my ColdFusion 7 application. If I run the
> actual query from CF7 it returns the proper number of rows in the
> result set, but the stored procedure only returns the 1st one. Can
> anyone see why I am not getting the entire result set. Here is the SP:

How is the SP called within ColdFusion?
Are you using EXECUTE PROCEDURE PROC_FINDPT?
Or, SELECT ... FROM PROC_FINDPT?

Usually for a selectable stored procedure, you need to use
SELECT ... FROM PROC_FINDPT(input params).

--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Consultants Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)