I am currently attempting to convert Java code into PHP, an in doing so have encounted errors calling MS SQL Stored Procedure.
I'm using standard code to connect:
$sql = "{ call sp_addMessage ($fromid, $toid, '$message', '".date("m/d/Y H:i:s")."', '14/06/2001 17:36:21', ".$distribution.") }";
$conn=mssql_connect("server","user","pwd");
mssql_select_db("dbname",$conn);
$this->result = @mssql_query($sql,$conn);
<font color=red><b>if ($this->result==FALSE) echo "$sql ... error!!";</b></font>
FALSE is returned (identified in red), and as a result i'm puzzled.
any help would be great
Craig
I'm using standard code to connect:
$sql = "{ call sp_addMessage ($fromid, $toid, '$message', '".date("m/d/Y H:i:s")."', '14/06/2001 17:36:21', ".$distribution.") }";
$conn=mssql_connect("server","user","pwd");
mssql_select_db("dbname",$conn);
$this->result = @mssql_query($sql,$conn);
<font color=red><b>if ($this->result==FALSE) echo "$sql ... error!!";</b></font>
FALSE is returned (identified in red), and as a result i'm puzzled.
any help would be great
Craig