X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 01F15D1B433 for ; Tue, 9 Dec 2003 08:46:40 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 86456-06 for ; Tue, 9 Dec 2003 04:46:10 -0400 (AST) Received: from neptune.adelis.net (neptune.adelis.net [195.115.171.102]) by svr1.postgresql.org (Postfix) with ESMTP id E961CD1B42F for ; Tue, 9 Dec 2003 04:46:07 -0400 (AST) Received: from icqmail.com (ben.adelis.net [195.115.171.16]) by neptune.adelis.net (Postfix) with ESMTP id DF6CE79498; Tue, 9 Dec 2003 09:10:17 +0100 (CET) Message-ID: <3FD585B3.7070302@icqmail.com> Date: Tue, 09 Dec 2003 09:20:03 +0100 From: BenLaKnet User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.5) Gecko/20031014 Thunderbird/0.3 X-Accept-Language: en-us, en MIME-Version: 1.0 Cc: Roberto Mello , viola , pgsql-sql@postgresql.org Subject: Re: postgresql and ColdFusion References: <20031209013856.51640.qmail@web40103.mail.yahoo.com> <20031209043119.GC28640@cc.usu.edu> <3FD58567.8080302@adelis.com> In-Reply-To: <3FD58567.8080302@adelis.com> Content-Type: multipart/alternative; boundary="------------010907080306010404050904" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/62 X-Sequence-Number: 16228 This is a multi-part message in MIME format. --------------010907080306010404050904 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit Benoît BOURNON wrote: > Oh dear a man using CF with postgresql ! ... OH YES ! ... > > try to use jdbc pilot to connect to postgresql with CFMX ... > maybe you can use cfstoredproc with cfprocparam and cfprocrsult > > Roberto Mello wrote: > >>On Mon, Dec 08, 2003 at 05:38:56PM -0800, viola wrote: >> >> >>>Hi, >>>How to call PostgreSql function from ColdFusion, if >>>that function returns result set using cursor? >>> >>> >> >>Through ODBC. Don't know it they have native access now. >> >>-Roberto >> >> >> --------------010907080306010404050904 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit

Benoît BOURNON wrote:
Oh dear a man using CF with postgresql ! ... OH YES ! ...

try to use jdbc pilot to connect to postgresql with CFMX ...
maybe you can use cfstoredproc with cfprocparam and cfprocrsult

Roberto Mello wrote:
On Mon, Dec 08, 2003 at 05:38:56PM -0800, viola wrote:
  
Hi, 
How to call PostgreSql function from ColdFusion, if 
that function returns result set using cursor? 
    

Through ODBC. Don't know it they have native access now.

-Roberto

  
--------------010907080306010404050904--