Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default database commit

    When is a database insert committed? Immediately or is it committed at the end of a transaction, and if so, what are transaction end points?

    Terry Percival
    KJLTerry Guest

  2. Similar Questions and Discussions

    1. cftransaction, commit, & security
      I'm specifying the username and password in the cfquery tag and not in CF Admin as this is how my ISP needs it. <cfquery name="getID"...
    2. rollback or commit?
      I have the index.cfm page that contain the delete and insert statement. Every time I run this page, It's delete all the old records and insert the...
    3. "Full Edit" Paging w/ DataBase Commit
      I am using the DataGrid that I am working with in "full edit" mode. In other words, there are editable TextBoxes in all the rows of the grid. I want...
    4. Commit Status After Failure
      Hi! Does anyone know of any database product or an API which supports the concept of an asynchronous commit status reporting? What I mean by...
    5. Commit Control
      My company is porting some software that we have running on Oracle and DB2 to SQL Server. For our big batch programs(Microfocus COBOL) we have a...
  3. #2

    Default Re: database commit

    Inserts are committed immediately, unless your controlling it with <cftransaction>.
    eastinq Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139