Thomas_Bode

Adding more what? This is an error msg i get: In read_production_data Array ( [0] => Array ( [0] => IMSSP [SQLSTATE] => IMSSP [1] => -16 => -16 [2] => An invalid PHP type for parameter 1 was specified. [message] => An invalid PHP type for parameter 1 was specified. ) )

$myPMSource = "FANESTRA5"; $period = -8; $myDB = "dog"; $myCLSource = "cat"; $sql = "{CALL retrieveproductiondata(?,?)}"; $params = array(array($myPMSource, SQLSRV_PARAM_IN, $period, SQLSRV_PARAM_IN), array($myDB, SQLSRV_PARAM_INOUT, $myCLSource, SQLSRV_PARAM_INOUT)); $stmt = sqlsrv_query($aconn, $sql, $params); All of the web examples show and work with just one parameter of each. I have not been able to find the proper syntax for multiples.