Hi,
Is there any way to retrieve a select statement used in a mssql stored procedure.
ex:
----
CREATE PROCEDURE test
AS
SELECT col1, col2
FROM table1
-----
How can I fetch the SELECT
mssql_fetch_field is OK and returns the fields
but mssql_fetch_array returns nothing
If impossible with the mssql layer, can I do it with ODBC ?
ps:
WIN2K, apache 1.3.12, SQL7, PHP4.0.3pl1
Thanx for any help
JB
Is there any way to retrieve a select statement used in a mssql stored procedure.
ex:
----
CREATE PROCEDURE test
AS
SELECT col1, col2
FROM table1
-----
How can I fetch the SELECT
mssql_fetch_field is OK and returns the fields
but mssql_fetch_array returns nothing
If impossible with the mssql layer, can I do it with ODBC ?
ps:
WIN2K, apache 1.3.12, SQL7, PHP4.0.3pl1
Thanx for any help
JB