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