|
|
|||||||||
|
|||||||||
|
|||||||||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
Ajax Application Generator Generate database and reporting .NET Web apps in minutes. Quickly create visually stunning, feature-rich apps that are easy to customize and ready to deploy. Download Now!
|
|
#1
|
|||
|
|||
|
SQL Stored procedures in PHP
Hi !
I never called stored procedures, located on a MSSQL server before. Now, i have problems, to get the return value from my stored procedure. I will show you the code i use: $s = @mssql_connect($myServer, $myUser, $myPass) or die("Couldn't connect to SQL Server on $myServer"); $d = @mssql_select_db($myDB, $s) or die("Couldn't open database $myDB"); $puserId = 'test'; $pPassword = 'test'; $query = mssql_init("dbo.proc_login_registrar", $s); mssql_bind($query, "@puserid", $puserId, SQLVARCHAR ,false,false,15); mssql_bind($query, "@ppassword", $pPassword, SQLVARCHAR,false,false,20); mssql_bind($query, "@pRetVal", $pRetVal, SQLINT2, true); mssql_execute($query); //-------------------------------------------------------------------------- My stored procedure returns the userid of the user. If no entry found, it returns a -1 value. My problem is, that the variable for the return value is not "touched". That means, the return value is not given back. What i'm doing wrong ??? Thanks, bernd |
![]() |
| Viewing: Dev Articles Community Forums > Programming > PHP Development > SQL Stored procedures in PHP |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|