...

View Full Version : results are not retrieved if temp tables are used in stored procedure not



shaileshpatil
04-30-2009, 08:11 AM
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



$sql="Exec up_parmsel_inspectionreportstatus_dashboard";
$data_arr = $db->getAll($sql, DB_FETCHMODE_ASSOC);
print_r ($data_arr);

Whats going wrong?

Thanks

shaileshpatil
05-02-2009, 05:36 AM
Please help me out. or suggest a different solution.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum