Re: [PHP-WIN] SQL Server stored procedures and functions

2001-05-23 Thread Paco Ortiz
Hi, >You should submit them again for inclusion - these would be really useful >for lot's of people. Myabe they just got missed. The maintainer for MSSQL >is Frank Kromann. I used to be in touch with Frank Kromann, and he told me this would be included in 4.0.5. Anyway, he also said he would b

Re: [PHP-WIN] SQL Server stored procedures and functions

2001-05-23 Thread Peter
Hi Paco You should submit them again for inclusion - these would be really useful for lot's of people. Myabe they just got missed. The maintainer for MSSQL is Frank Kromann. Cheers Peter "Paco Ortiz" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi, >

RE: [PHP-WIN] SQL Server stored procedures and functions

2001-05-23 Thread Paco Ortiz
Hi, >Two problems with stored procedures, no return value and no output >parameters. You'll need to reformat all your procedures to have a SELECT >statement return those values. > >I've been told that the 4.0.6 (as of yet unreleased) version has better >support for stored procedures. You might wa

RE: [PHP-WIN] SQL Server stored procedures and functions

2001-05-22 Thread andrew morton
ailed"); $obj = mssql_fetch_object($query_result); if ($obj==FALSE) die("query failed"); //read out your return values mssql_free_result($query_result); mssql_close($connection); -Original Message- From: Pavel Kalian [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 22, 2001

Re: [PHP-WIN] SQL Server stored procedures and functions

2001-05-22 Thread Pavel Kalian
It sure can. example: $result = mssql_query("execute your_proc '$your_var', $another_var"); note that you will probably have to go with the CGI version under IIS as the ISAPI one is EXTREMELY unstable when used with MS SQL Server in my experience. Pavel - Original Message - From: "Scot