[PHP-DB] help: running a stored proc on mssql 2000

[david . tansley]

Hi,
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.)

Thanks
DT




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] help: running a stored proc on mssql 2000

[D E Neil]

 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


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]