Yep....its a real bitch to confirm..... (we have one which returns back around 10 resultsets). The actual SP is doing the usual...inner/outer joins...couple of other things...
It fails on the large resultset...we strip that query out and put it in its own SP and it will work AOK!? Wierd...I currently have an MM issue open with it. -----Original Message----- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 22 October 2003 11:30 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Performance > True....very true.... The error with CFSTOREDPROC seems to be > where your first resultset is bringing back a row with > multiple TEXT Datatypes. Curious. I have several SPs that do this without problem. -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
