Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Nov 2006
    Location
    INDIA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    results are not retrieved if temp tables are used in stored procedure not

    Dear All
    I have created a stored procedure which first creates an temporary table, insert the values and queries it. This works perfectly in MSSQL management studio, but when i try to execute the same procedure using php, it does not returns any rows.

    I am using PEAR DB and MSSQL 2005

    PHP Code:
    $sql="Exec up_parmsel_inspectionreportstatus_dashboard";
    $data_arr $db->getAll($sqlDB_FETCHMODE_ASSOC);
    print_r ($data_arr); 
    Whats going wrong?

    Thanks
    Last edited by shaileshpatil; 04-30-2009 at 09:58 AM. Reason: change subject
    -------------------------
    Shailesh Patil
    -------------------------

  • #2
    New Coder
    Join Date
    Nov 2006
    Location
    INDIA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Please help me out. or suggest a different solution.
    -------------------------
    Shailesh Patil
    -------------------------


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •