Hi,
I'm using PHP4/Apache/MSSQL2000, and when i try to perform one SQL statement into php script, i get error's message:
"No tuples available at this result index in"
I set the odbc_connect with SQL_CUR_USE_ODBC, but nothins happened! The strange that only single queries like "Select * from SomeTable" works fine, but when i try to perform multiples SQL's statements i get this error (for exemple: If my first statement is one insert,update or store procedure, the SQL's parser return in MSSQL console:"1 line affected or the command was completed with successful". and in sequence the parse will perform the rest of query, and at the final will return another message like:"1 line affected or the command was completed with successful.") How PHP's ODBC implementation treat the execution of multiples SQL statements in this context? I'm trying to run one store procedure that return a variable. In MSSQL console this work fine. But in a PHP script i get a message error "No tuples....". Does anybody know how i can solve this problem?
Thanks a lot,
Ricardo Perrone
