This might be a very silly question. I am trying to execute a query using PHP and MSSQL.
BEGIN
IF NOT EXISTS(SELECT * FROM Table1 WHERE Col1 = 170 AND Col2 = 'Test')
INSERT INTO Table1 (Col1, Col2)
VALUES(170, 'Test')
END
when called mssql_rows_affected() after executing the query it returns -1.
When I execute same query on database directly I get message Command(s) completed successfully. That means my query have no errors (though it is not affecting any records).
Additionally return code for the query is 1 (I hope that means query executed successfully)
I have looked on PHP manual but it says Returns the number of records affected by last operation. It doesn't mention what if it returns -1.
Does anybody know what mssql_rows_affected() = -1 means?
Thanks in advance.
Regards, Ganesh.
