Output variables?

janet287

Hi,

Sorry for the bunch of posting. When it rains, it pours with questions. I am pasting a stored procedure call below that I need to use. The stored procedure outputs 2 variables "login_id" and "password". Do I need to specify those in this call at all? Right now it isn't producing an error but it isn't working either? How do I tell it what output to expect or do it automatically know?

elseif($this->config->passtype === 'pc' and preg_match('/^P\d{9}$/', $password))
{$sp = mssql_init("unx_sp_unexMoodleSSI"); // stored proc name

mssql_bind($sp, "@session_id", ($extusername), SQLVARCHAR, false, false, 255);
mssql_bind($sp, "@people_code_id", ($extpassword), SQLVARCHAR, false, false, 255);

mssql_execute($sp);

Thanks!

NogDog

I have not worked with those functions, so this is just my best guess from looking at the manual. It looks to me like you could add another couple of mssql_bind() calls for those outputs, specifying "true" for the 5th argument.

janet287

I added variables for login_id and password as shown below but it says I have too many arguments. The login_id and password aren't input, just output. Any ideas? What did you mean by the 5th argument?

elseif($this->config->passtype === 'pc' and preg_match('/^P\d{9}$/', $extpassword))
{$sp = mssql_init("unx_sp_unexMoodleSSI"); // stored proc name

mssql_bind($sp, "@session_id", ($extusername), SQLVARCHAR, false, false, 255);
mssql_bind($sp, "@people_code_id", ($extpassword), SQLVARCHAR, false, false, 255);
mssql_bind($sp, "@login_id", ($extusername), SQLVARCHAR, true, false, 255);
mssql_bind($sp, "@password", ($extpassword), SQLVARCHAR, true, false, 255);

mssql_execute($sp);

NogDog

Maybe try it without the optional arguments at the end? (Also, there's no purpose I can see for the parentheses around the 3rd argument.)

mssql_bind($sp, "@login_id", $extusername, SQLVARCHAR, true);
mssql_bind($sp, "@password", $extpassword, SQLVARCHAR, true);

Unfortunately, the doucmentation seems lacking on the php.net site, and I don't have any way to test it.