Thread: postgresql and ColdFusion

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

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

<br /><br /> Benoît BOURNON wrote:<br /><blockquote cite="mid3FD58567.8080302@adelis.com" type="cite"></blockquote> Oh
deara 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
/><blockquotecite="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>

Oh dear a man using CF with postgresql ! ... OH YES ! ...<br /><br /> try to use jdbc pilot to connect to postgresql
withCFMX ... <br /> maybe you can use cfstoredproc with cfprocparam and cfprocrsult<br /><br /> Roberto Mello wrote:<br
/><blockquotecite="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>