Skip to main content
A
Anonymous
November 30, 2009
Question

SQL Server 2000 - Before Commiting the transaction.

  • November 30, 2009
  • 2 replies
  • 389 views

Hi All,

I am using CF7 along with SQL Server 2000.

And I am in a situation where I need to update some set of data to make sure that the changes are getting reflected in the front end.

My approach is like, trying some update statements inside "Begin Tran" block.

It goes like this,

begin tran
update table1 set field1='value' where cond='condition';

And I am just refreshing my application (in the browser). But unusually it takes a bit time to load, and no records are being pulled out after that..

My question is, do I need to perform a "Commit" to avoid this hanging kinda behaviour?.

Any ideas?.

    This topic has been closed for replies.

    2 replies

    D
    Dan_Bracuk
    Inspiring
    December 5, 2009

    Do your update first.  Then do a select and display the results.

    J
    JR__Bob__Dobbs-qSBHQ2
    Inspiring
    December 4, 2009

    I'm not sure I fully understand your issue, but I suspect that you will need to commit the transaction before that changes will be available to your web site.  If your changes are in one UPDATE statement a transaction isn't usually required since this is a single statement.  Database transactions are intended to group multiple SQL statements into a single block so that all changes will succeed or all will fail.

    Please post your CF and SQL code and the steps to re-create your issue.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices