Re: help: running a stored proc on mssql 2000
| From: | D & E Neil | Date: | Tue, 13 Nov 2001 20:10:33 +0000 |
| Subject: | Re: help: running a stored proc on mssql 2000 | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-14295@lists.php.net to get a copy of this message | ||
> I am trying to run the SP 'sp_password' on mssql, using this command:
> $sql="exec sp_password 'NULL','master','davet')";
> Is that the correct way ???
>
> But when I run my script I get a error with this statement.. saying "Incorrect syntax near
> ')' "
> $sql_result=mssql_query($sql,$connection);
>
> Can't figure the problem. Any idea's. Also,
> how do I check the returned status ?
>
> (linux, using freetds connecting to ms-sql.)
DT,
Are there matching parentheses in the code?
=dn