Result set return to Coldfusion MX?

From: Avi Schwartz <avi(at)CFFtechnologies(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Result set return to Coldfusion MX?
Date: 2003-05-16 23:24:07
Message-ID: 7D584CE8-87F5-11D7-B5B7-000393AE5044@CFFtechnologies.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)CFFtechnologies(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message elein 2003-05-16 23:27:13 Re: context in plpgsql functions
Previous Message Chris Palmer 2003-05-16 23:09:33 Re: priority on a process