Posted by Jerry Stuckle on 07/15/06 12:04

~john wrote:
> Jerry Stuckle wrote:
>
>
>>John,
>>
>>Why not try asking in a MySQL newsgroup, like comp.databases.mysql?
>
>
>
>
> SQL Server... but anyway, I'm asking because the calling code is PHP.
> The SQL by itself runs fine in SQL Server's query analzyer.
>
> ~john
>

John,

Sorry - shouldn't try to replay late at night. I say mysql when you
were saying mssql.

OK, it works with SQL Server's query analyzer, so your logic is OK. But
it looks you're not actually using transactions - it's seems to be
committing after each request. There are no options in PHP to control
this. But what about SQL Server?

I would still start with a SQL Server newsgroup. That's where you're
seeing the problem, not in PHP. And that's where your troubleshooting
should start.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

• Next in forum: Re: multidimensional array declaration in php
• Prev in forum: Re: "call to undefined function" mysql_error when adding new rows to table
• Thread view: Re: Transactions in PHP on SQL Server 2005

[Reply to this message]