[PHP-DB] "stored procedure execution failed"

2008-08-25 Thread bertrand . lods
Hi everyone I have some problem with stored procedure. I work on trustix web server ( LAMP ), and my database run on MsSql Server 2005. I try to lauch my stored procedure from PHP like this : [code] $tableau=array(); // connexion à la base mssql => $connexion_base = identifiant de lien MS

Re: [PHP-DB] Stored procedure with UNION---no unique id, how to page?

2004-02-19 Thread John W. Holmes
Karen Resplendo wrote: I have a stored procedure in msSQL that UNIONs 3 queries. There is no unique identifier that is sequential that I can use to page on webpage because the data comes from different tables/databases. Would you be able to use mssql_data_seek() to jump to the result set row tha

[PHP-DB] Stored procedure with UNION---no unique id, how to page?

2004-02-19 Thread Karen Resplendo
I have a stored procedure in msSQL that UNIONs 3 queries. There is no unique identifier that is sequential that I can use to page on webpage because the data comes from different tables/databases. Is there a way to save the resultset into a temp table and add an @@Identity(autonumber) to it? F

Re: [PHP-DB] Stored Procedure

2001-09-07 Thread Thies C. Arntzen
On Tue, Sep 04, 2001 at 07:44:42AM -0800, [EMAIL PROTECTED] wrote: > Hello everyboby! > > this is my first time on this list and I writing to ask for help on SP. > > I have the following code calling a Procedure: > > > > $c=OCILogon("SYSTEM","manager"); > $x =0; > $cpf="10001628852"; >

[PHP-DB] stored procedure -- SQL Server 2k

2001-09-06 Thread bona
Hi, does anybody know to call an SP on a SQL Server 2k??? thanks Bona __ Visite http://www.trama.com.br -- 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

[PHP-DB] Stored Procedure

2001-09-04 Thread bona
Hello everyboby! this is my first time on this list and I writing to ask for help on SP. I have the following code calling a Procedure: and I having this error message: Fatal error: Only variables can be passed by reference in c:\program files\apache group\apache\htdocs\testes\procedure5