Page 1 of 1

Hello - Me Again: 4.3.3 & mssql query

Posted: Tue Aug 26, 2003 7:05 pm
by NoReason
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

Posted: Tue Aug 26, 2003 9:21 pm
by BDKR
Did you check with the PHP-DEV list or bug list? Or even the changelog? If something was changed (that is a known change), it would be there.

Otherwise, they may have inadvertently introduced a bug.

Are you getting a php specific error? It doesn't sound like it, in which case, I'd double check error or log information (if any) coming from the db before venturing to ask questions on the list.

Cheers,
BDKR