Re: Result set return to Coldfusion MX?

Avi Schwartz <avi@CFFtechnologies.com> writes:

> Hi,
>
> We are currently running in a mostly Linux environment except for one
> (big) thing, the database server.  We are currently using Coldfusion
> MX running on Linux and MS SQL Server but we are trying to get off SQL
> Server into a Linux DB.  The thing is  that we are using stored
> procedures very heavily and these stored procedures return a result
> set in many cases.  I tried to use a pl/pgsql function to return a
> result set but it seems that Coldfusion MX does not know what to do
> with the refcursor that PostgreSQL is providing.  Is there another way
> to return a result set to CF that it can handle?  This is definitely a
> show stopper for us.

Have you tried using 7.3's set returning functions?  See the docs...

-Doug