Can you post your stored proc? I'd like to run some tests and see what I can find out...
-- Josh Trefethen :::::[ Exciteworks, Inc ]::[ http://exciteworks.com ]:::::. ::[ cf hosting on linux ]::[ consulting ]::[ expertise ]::. -----Original Message----- From: Toby Tremayne [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 1:56 AM To: CF-Linux Subject: Re[2]: refcursors in postgres Hi Josh, via a cfstored proc - here's the code: <cftransaction> <cfstoredproc datasource="myDataSource" procedure="poptions" returncode="no"> <cfprocparam value="1" type="In" cfsqltype="CF_SQL_INTEGER" null="no"> <cfprocresult name="pOptions"> </cfstoredproc> </cftransaction> any clues? I was starting to wonder if this was just something I couldn't fix... cheers, 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
