Are you calling the stored proc via cfstored proc or via cfquery? -- Josh Trefethen
:::::[ Exciteworks, Inc ]::[ http://exciteworks.com ]:::::. ::[ cf hosting on linux ]::[ consulting ]::[ expertise ]::. -----Original Message----- From: Toby Tremayne [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 2:38 PM To: CF-Linux Subject: refcursors in postgres Hi all, anyone here use postgres stored procs/functions to return a ref cursor? I've built my stored procedure, it does what I want and returns a refcursor. When I use "fetch all" it shows me the records I expect to see, but in cold fusion when I dump the results of the storedproc call it's an empty query. Can anyone tell me how to extract the row data from an unnamed cursor for cold fusion? Toby --------------------------------------- Life is poetry - write it in your own words. --------------------------------------- Toby Tremayne Senior Technical Consultant Code Poet and Zen Master of the Heavy Sleep Lyricist Software www.lyricist.com.au 0416 048 090 ICQ: 13107913 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=14 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=14 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
