Re: SQL SERVER - Can't apply changes to database

I suppose it deals with transaction... or a transaction related to my session... but I don't know how to commit this data.... I'm gettig crazy with it. SQL Profiler registers my instructons with no rollback or begin transaction... but... remais the same... no data is saved... -----Mensagem Original----- De: "John W. Holmes" <holmes072000@charter.net> Para: "'Emerson Donizeti Batista'" <emebatista@microsiga.com.br>; <php-general@lists.php.net> Enviada em: Quinta-feira, 10 de Abril de 2003 23:50 Assunto: RE: [PHP] SQL SERVER - Can't apply changes to database > > I'm using (for test purposes) Windows 98 / Apache 1.3.14 / PHP 4.3.1 / > SQL > > SERVER 7.0 > > The script below makes a change on the the Northwind Database. This is > the > > sequence: > > > > 1 - UPDATE Employees table > > 2 - SELECT Employees table > > 3- SHOW the results > > > > When I run the script, the SELECT part shows that my update was ok. > > But If I call the php script again, my changes were not saved. If I > use > > query analyzer, I make changes normally. The SQL Profiler registers > the > > instructions... but no change is applied to my database. > > Is it maybe some transaction issue? Like the change is not committed, so > it's not actually kept once the script ends? I'm grasping at straws > here... :) > > ---John W. Holmes... > > PHP Architect - A monthly magazine for PHP Professionals. Get your copy > today. http://www.phparch.com/ > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php