Hello - Me Again: 4.3.3 & mssql query

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
NoReason
Forum Commoner
Posts: 51
Joined: Tue Sep 10, 2002 6:19 pm

Hello - Me Again: 4.3.3 & mssql query

Post 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
User avatar
BDKR
DevNet Resident
Posts: 1207
Joined: Sat Jun 08, 2002 1:24 pm
Location: Florida
Contact:

Post 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
Post Reply