5 Replies Latest reply on May 11, 2007 3:00 PM by insuractive

    Blank CF Pages When using stored procedures

    bemall Level 1
      Windows XP SP2, IIS, SQL 2005 and CFMX 7,0,2,142559 .

      Issue: I have queries within the CFML pages coded using <cfquery>. Converting these to <cfstoredproc> leads to a blank cfml page with no errors in the exception, server or application log.
      I ran a profiler trace on the database and I can see the stored proc getting executed but still get a blank page.
      Executing an testing the queries in Management studio\query aalyzer works successfully.

      Any ides on the cause of this.