From viola816@yahoo.com Mon Dec  8 23:24:04 2003
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 3B619D1B8CB
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  8 Dec 2003 23:24:04 +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 17878-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  8 Dec 2003 19:23:35 -0400 (AST)
Received: from web40103.mail.yahoo.com (web40103.mail.yahoo.com
 [66.218.78.37])
	by svr1.postgresql.org (Postfix) with SMTP id F1D63D1B469
	for <pgsql-sql@postgresql.org>; Mon,  8 Dec 2003 19:23:09 -0400 (AST)
Message-ID: <20031208232307.23280.qmail@web40103.mail.yahoo.com>
Received: from [135.214.154.104] by web40103.mail.yahoo.com via HTTP;
	Mon, 08 Dec 2003 15:23:07 PST
Date: Mon, 8 Dec 2003 15:23:07 -0800 (PST)
From: viola <viola816@yahoo.com>
Subject: postgresql and ColdFusion
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1444055494-1070925787=:22764"
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.7 tagged_above=0.0 required=5.0
	tests=FROM_ENDS_IN_NUMS, HTML_50_60
X-Spam-Level: 
X-Archive-Number: 200312/58
X-Sequence-Number: 16224

--0-1444055494-1070925787=:22764
Content-Type: text/plain; charset=us-ascii


Hi,

Does anybody know how to call PostgreSql function from ColdFusion, if that function returns cursor?

 

Thank you.



---------------------------------
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing
--0-1444055494-1070925787=:22764
Content-Type: text/html; charset=us-ascii

<DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>Hi,</FONT></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>Does anybody know how to call PostgreSql function from ColdFusion, if that function returns cursor?</FONT></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p><FONT face="Times New Roman" size=3>&nbsp;</FONT></o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>Thank you.</FONT></P></DIV><p><hr SIZE=1>
Do you Yahoo!?<br>
<a href="http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=21260/*http://photos.yahoo.com">New Yahoo! Photos - easier uploading and sharing</a>
--0-1444055494-1070925787=:22764--



From viola816@yahoo.com Tue Dec  9 01:39:25 2003
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 0F67ED1B449
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue,  9 Dec 2003 01:39:25 +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 32530-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  8 Dec 2003 21:38:56 -0400 (AST)
Received: from web40103.mail.yahoo.com (web40103.mail.yahoo.com
 [66.218.78.37])
	by svr1.postgresql.org (Postfix) with SMTP id B9104D1B48B
	for <pgsql-sql@postgresql.org>; Mon,  8 Dec 2003 21:38:52 -0400 (AST)
Message-ID: <20031209013856.51640.qmail@web40103.mail.yahoo.com>
Received: from [135.214.154.104] by web40103.mail.yahoo.com via HTTP;
	Mon, 08 Dec 2003 17:38:56 PST
Date: Mon, 8 Dec 2003 17:38:56 -0800 (PST)
From: viola <viola816@yahoo.com>
Subject: postgresql and ColdFusion
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-361036140-1070933936=:49317"
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=2.1 tagged_above=0.0 required=5.0
	tests=FROM_ENDS_IN_NUMS, HTML_20_30
X-Spam-Level: **
X-Archive-Number: 200312/59
X-Sequence-Number: 16225

--0-361036140-1070933936=:49317
Content-Type: text/plain; charset=us-ascii

Hi, 
How to call PostgreSql function from ColdFusion, if 
that function returns result set using cursor? 

Thank you. 



---------------------------------
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing
--0-361036140-1070933936=:49317
Content-Type: text/html; charset=us-ascii

Hi, <BR>How to call PostgreSql function from ColdFusion, if <BR>that function returns result set using cursor? <BR><BR>Thank you. <BR>
<DIV></DIV><p><hr SIZE=1>
Do you Yahoo!?<br>
<a href="http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=21260/*http://photos.yahoo.com">New Yahoo! Photos - easier uploading and sharing</a>
--0-361036140-1070933936=:49317--



From rmello@cc.usu.edu Tue Dec  9 04:32:08 2003
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 0EF1CD1B46D
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue,  9 Dec 2003 04:32:08 +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 57549-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue,  9 Dec 2003 00:31:37 -0400 (AST)
Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.227.103])
	by svr1.postgresql.org (Postfix) with ESMTP id EA081D1B49B
	for <pgsql-sql@postgresql.org>; Tue,  9 Dec 2003 00:31:21 -0400 (AST)
Received: from roberto by brasileiro.net with local (Exim 3.36 #1 (Debian))
	id 1ATZWq-0007TZ-00; Mon, 08 Dec 2003 21:31:20 -0700
Date: Mon, 8 Dec 2003 21:31:20 -0700
From: Roberto Mello <rmello@cc.usu.edu>
To: viola <viola816@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: postgresql and ColdFusion
Message-ID: <20031209043119.GC28640@cc.usu.edu>
References: <20031209013856.51640.qmail@web40103.mail.yahoo.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
In-Reply-To: <20031209013856.51640.qmail@web40103.mail.yahoo.com>
X-message-flag: Please consider using an e-mail program other than Outlook.
	It's insecure.
User-Agent: Mutt/1.5.4i
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200312/60
X-Sequence-Number: 16226

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

-- 
+----|        Roberto Mello   -    http://www.brasileiro.net/  |------+
+       Computer Science Graduate Student, Utah State University      +
+       USU Free Software & GNU/Linux Club - http://fslc.usu.edu/     +
If at first you don't succeed, you must be using Windows ...



From benoit.bournon@adelis.com Tue Dec  9 08:29:17 2003
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 388EFD1B46E
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue,  9 Dec 2003 08:29:17 +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 83637-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue,  9 Dec 2003 04:28:47 -0400 (AST)
Received: from neptune.adelis.net (neptune.adelis.net [195.115.171.102])
	by svr1.postgresql.org (Postfix) with ESMTP id 4D2A1D1B439
	for <pgsql-sql@postgresql.org>; Tue,  9 Dec 2003 04:28:44 -0400 (AST)
Received: from adelis.com (ben.adelis.net [195.115.171.16])
	by neptune.adelis.net (Postfix) with ESMTP
	id BD49779493; Tue,  9 Dec 2003 09:09:01 +0100 (CET)
Message-ID: <3FD58567.8080302@adelis.com>
Date: Tue, 09 Dec 2003 09:18:47 +0100
From: =?ISO-8859-1?Q?Beno=EEt_BOURNON?= <benoit.bournon@adelis.com>
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
To: Roberto Mello <rmello@cc.usu.edu>
Cc: viola <viola816@yahoo.com>, pgsql-sql@postgresql.org
Subject: Re: postgresql and ColdFusion
References: <20031209013856.51640.qmail@web40103.mail.yahoo.com>
	<20031209043119.GC28640@cc.usu.edu>
In-Reply-To: <20031209043119.GC28640@cc.usu.edu>
Content-Type: multipart/alternative;
	boundary="------------030803040303080408090603"
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.6 tagged_above=0.0 required=5.0
	tests=EMAIL_ATTRIBUTION, HTML_20_30, IN_REP_TO, REFERENCES,
	REPLY_WITH_QUOTES, USER_AGENT_MOZILLA_UA
X-Spam-Level: 
X-Archive-Number: 200312/65
X-Sequence-Number: 16231

This is a multi-part message in MIME format.
--------------030803040303080408090603
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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
>
>  
>

--------------030803040303080408090603
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
  <title></title>
</head>
<body>
Oh dear a man using CF with postgresql ! ... OH YES ! ...<br>
<br>
try to use jdbc pilot to connect to postgresql with CFMX ... <br>
maybe you can use cfstoredproc with cfprocparam and cfprocrsult<br>
<br>
Roberto Mello wrote:<br>
<blockquote type="cite" cite="mid20031209043119.GC28640@cc.usu.edu">
  <pre wrap="">On Mon, Dec 08, 2003 at 05:38:56PM -0800, viola wrote:
  </pre>
  <blockquote type="cite">
    <pre wrap="">Hi, 
How to call PostgreSql function from ColdFusion, if 
that function returns result set using cursor? 
    </pre>
  </blockquote>
  <pre wrap=""><!---->
Through ODBC. Don't know it they have native access now.

-Roberto

  </pre>
</blockquote>
</body>
</html>

--------------030803040303080408090603--




From benlaknet@icqmail.com Tue Dec  9 08:46:40 2003
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 <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	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 <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	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 <pgsql-sql@postgresql.org>; 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 <benlaknet@icqmail.com>
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 <rmello@cc.usu.edu>, viola <viola816@yahoo.com>,
	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

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
  <title></title>
</head>
<body>
<br>
<br>
Beno&icirc;t BOURNON wrote:<br>
<blockquote type="cite" cite="mid3FD58567.8080302@adelis.com">
  <meta content="text/html;" http-equiv="Content-Type">
  <title></title>
Oh dear a man using CF with postgresql ! ... OH YES ! ...<br>
  <br>
try to use jdbc pilot to connect to postgresql with CFMX ... <br>
maybe you can use cfstoredproc with cfprocparam and cfprocrsult<br>
  <br>
Roberto Mello wrote:<br>
  <blockquote cite="mid20031209043119.GC28640@cc.usu.edu" type="cite">
    <pre wrap="">On Mon, Dec 08, 2003 at 05:38:56PM -0800, viola wrote:
  </pre>
    <blockquote type="cite">
      <pre wrap="">Hi, 
How to call PostgreSql function from ColdFusion, if 
that function returns result set using cursor? 
    </pre>
    </blockquote>
    <pre wrap=""><!---->
Through ODBC. Don't know it they have native access now.

-Roberto

  </pre>
  </blockquote>
</blockquote>
</body>
</html>

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