Hello - Me Again: 4.3.3 & mssql query
Posted: Tue Aug 26, 2003 7:05 pm
Does anyone know if there was anything changed in mssql_query in that it will not proccess a batch tsql statment using the tsql function exec()
For some reason it will process the query fine, but it will not return the information I have stated it to return in the transaction.
$tsql = "
exec('
TSQL TRANS
Either return error(rollback)
or return success (commit)
')
";
The return is just a SELECT ### as AlertCode
where ### is a predefined error code.
it will either return nothing (false) or part of the transaction select query, depending if i am returning a item or signing one out.
God today has been wicked.. .i may just switch back to 4.2.2
For some reason it will process the query fine, but it will not return the information I have stated it to return in the transaction.
$tsql = "
exec('
TSQL TRANS
Either return error(rollback)
or return success (commit)
')
";
The return is just a SELECT ### as AlertCode
where ### is a predefined error code.
it will either return nothing (false) or part of the transaction select query, depending if i am returning a item or signing one out.
God today has been wicked.. .i may just switch back to 4.2.2