PHP mssql_bind传递金钱数据类型失败


PHP mssql_bind passing money datatype failed

我试图从PHP调用mssql存储过程,当试图传递money参数时失败。这是我的代码:

$proc = mssql_init("sp_something");
mssql_bind($proc, "@param1", $param1,  SQLINT4, false, false);
mssql_bind($proc, "@param2", $param2,  SQLINT4, false, false);
mssql_bind($proc, "@param3", $param3,  SQLVARCHAR, false, false, 5);
mssql_bind($proc, "@param4", $param4,  SQLINT4, false, false);
mssql_bind($proc, "@param5", $param5,  SQLMONEY, false, false);
mssql_bind($proc, "@param6", $param6,  SQLMONEY, false, false);
mssql_bind($proc, "@param7", $param7,  SQLVARCHAR, true);
mssql_execute($proc);
echo mssql_get_last_message();

失败,最后一条消息是:

Procedure or function 'sp_something' expects parameter '@param5', 
which was not supplied.

这是我的存储过程:

ALTER PROCEDURE [dbo].[sp_something]
@param1 smallint,
@param2 smallint,
@param3 varchar(8),
@param4 int,
@param5 money,
@param6 money,
@param7 bit OUTPUT AS
--some stored proc

i try exec from sql server management studio and its SUCCESS:

exec sp_something 2014,5,'123456',1,12345.23,22222.33,0
当你想传递money数据类型时,有什么棘手的方法吗?因为我有另一个没有money参数的存储过程,它运行得很顺利。

所以最后我只使用SQLVARCHAR作为货币参数,它工作得很好

mssql_bind($proc, "@param5", $param5,  SQLVARCHAR, false, false);
mssql_bind($proc, "@param6", $param6,  SQLVARCHAR, false, false);