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

Emerson, I would consider echoing the sql statements you are using to your browser for example. Then, using the exact statements that your code produces, try them using the SQL client that comes with the DBMS. That way you can tell whether your statements themselves work, and what effect they SHOULD have on the database. Cheers, James. >>> "Emerson Donizeti Batista" <emebatista@microsiga.com.br> 04/11/03 11:11AM >>> 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php