I am using php odbc functions to connect to a MSSQL db and run stored procedures. usually, the procedures i use return record sets which are easy enough to extract data from using odbc_fetch_row() odbc_result() etc..
Unfortunately i have been given a set of stored procedures that return variables intead of record sets. i have been going through the odbc functions in the php manual and cant for the life of me figure out how to access them. obviously fetch_row and _result dont work and neither does anything else. i always seem to get "No tuples available at this result index". i understand why this is so, but cant figue out the correct way to access the data...
any ideas or advice would be well and truly appreciated.