RE: [PHP-DB] Sql Server stored procedure strikes back
| From: | David V�zquez | Date: | Fri, 24 Nov 2000 12:24:44 +0000 |
| Subject: | RE: [PHP-DB] Sql Server stored procedure strikes back | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-4718@lists.php.net to get a copy of this message | ||
is there...
thanks anyway.
""Sanders, Nicholas"" <SandersN@logica.com> escribió en el mensaje
news:9BF54A52E1DFD311BC1000D0B73EADFE0135AC85@bell.logica.co.uk...
> 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...
> TU75
> > 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
>
> --
> 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
>