Professional Web Applications Themes

cftransaction question - Macromedia ColdFusion

Hi there ! Let's say i have a first query which inserts a new row in a table, then a second query (myquery) trying to get the id of the inserted row (with a select max(id) as myid). Obviously, i will put that into a cftransaction tag so i'm sure to get the proper id. But now, i add a cfset myvar = myquery.myid. Should the cfset be inside the cftransaction, or outside ? Does it make any differences ? Thanx for you inputs. Best regards,...

  1. #1

    Default cftransaction question

    Hi there ! Let's say i have a first query which inserts a new row in a table,
    then a second query (myquery) trying to get the id of the inserted row (with a
    select max(id) as myid). Obviously, i will put that into a cftransaction tag so
    i'm sure to get the proper id. But now, i add a cfset myvar = myquery.myid.
    Should the cfset be inside the cftransaction, or outside ? Does it make any
    differences ? Thanx for you inputs. Best regards,

    Netopole Guest

  2. #2

    Default Re: cftransaction question

    It can be outside, since myquery.myid are ColdFusion results which were retrieved
    inside the cftransaction tag. Once the result set is returned, you no longer care
    what DB changes occur.
    OldCFer Guest

  3. #3

    Default Re: cftransaction question

    Thanx, that's what i thought, but i wanted to make sure.
    Netopole Guest

Similar Threads

  1. cftransaction
    By mjwjal in forum Coldfusion Database Access
    Replies: 17
    Last Post: November 6th, 03:45 PM
  2. CFTransaction rollbacks
    By Jim-sama in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: July 11th, 06:28 PM
  3. CFtransaction error
    By Jim-sama in forum Coldfusion - Advanced Techniques
    Replies: 2
    Last Post: July 7th, 09:07 PM
  4. Error with cftransaction
    By gusvok in forum Macromedia ColdFusion
    Replies: 0
    Last Post: April 6th, 09:10 PM
  5. is this possible - cftransaction
    By jppa in forum Coldfusion - Advanced Techniques
    Replies: 4
    Last Post: March 1st, 08:51 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not 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