Result set return to Coldfusion MX? - Mailing list pgsql-general

From Avi Schwartz
Subject Result set return to Coldfusion MX?
Date
Msg-id 7D584CE8-87F5-11D7-B5B7-000393AE5044@CFFtechnologies.com
Whole thread Raw
List pgsql-general
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.

Thanks,
Avi
--
Avi Schwartz
avi@CFFtechnologies.com


pgsql-general by date:

Previous
From: "Chris Palmer"
Date:
Subject: Re: priority on a process
Next
From: elein
Date:
Subject: Re: context in plpgsql functions