RE: [PHP-DB] Sql Server stored procedure strikes back
| From: | Sanders, Nicholas | Date: | Fri, 24 Nov 2000 12:06:49 +0000 |
| Subject: | RE: [PHP-DB] Sql Server stored procedure strikes back | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-4716@lists.php.net to get a copy of this message | ||
Run the following query to see all the stored procedures and check its there
SELECT name FROM sysobjects WHERE type = 'P'
-----Original Message-----
From: David Vázquez [mailto:dvazquez@comunet.es]
Sent: 24 November 2000 11:23
To: php-db@lists.php.net
Subject: RE: [PHP-DB] Sql Server stored procedure strikes back
thanks, but unfortunately the dbname and the stored procedure name are
correct...
heeeeelp please!!
David.
""Sanders, Nicholas"" <SandersN@logica.com> escribió en el mensaje
news:9BF54A52E1DFD311BC1000D0B73EADFE0135AC82@bell.logica.co.uk...
> You can use 'exec' or 'execute' but you dont't have to
>
> i.e. $query = "procedurename parameter1, parameter2";
>
> but it sounds like you've got the stored procedure name wrong or its in
> another database
>
> Nick
>
>
>
> -----Original Message-----
> From: David Vázquez [mailto:dvazquez@comunet.es]
> Sent: 24 November 2000 08:30
> To: php-db@lists.php.net
> Subject: [PHP-DB] Sql Server stored procedure strikes back
>
>
> I am trying to execute a sql server stored procedure with the following
> code:
>
> MSSQL_CONNECT($hostname,$username,$password) or DIE("DATABASE FAILED TO
> RESPOND.");
> mssql_select_db($dbName) or DIE("Table unavailable");
> $query = "execute procedurename parameter1,parameter2";
> $result = MSSQL_QUERY($query);
>
>
> and this is the response,
>
> "Warning: MS SQL message: Could not find stored procedure 'procedurename'.
> (severity 16)"
>
> any ideas?
>
> Thanks,
>
> David.
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
For additional commands, e-mail: php-db-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net