Professional Web Applications Themes

is this possible - cftransaction - Coldfusion - Advanced Techniques

I don't want to get into the whole 'users shouldn't have access to the db' discussion. It's a battle that's been lost. We are looking at alternatives, one of which is to find out if it's possible to let a user submit a query thru CF module and then through the use of CFTRANSACTION allow the user to decide to commit or rollback. I understand that it's not pretty,, but is it possible? Our local expert says no, but our mgr wants something resembling proof. thanks in advance...

  1. #1

    Default is this possible - cftransaction

    I don't want to get into the whole 'users shouldn't have access to the db'
    discussion. It's a battle that's been lost. We are looking at alternatives,
    one of which is to find out if it's possible to let a user submit a query thru
    CF module and then through the use of CFTRANSACTION allow the user to decide to
    commit or rollback. I understand that it's not pretty,, but is it possible?
    Our local expert says no, but our mgr wants something resembling proof.
    thanks in advance

    jppa Guest

  2. #2

    Default Re: is this possible - cftransaction

    Hi

    do You mean to restrict the users not to submit the form?

    once the user submits then in the action form check for the author
    authentication...if its ok then go on otherwise just skip.it
    Is this what you want to do?

    vkunirs Guest

  3. #3

    Default Re: is this possible - cftransaction

    Actually I mean that they would submit their query in the form, but commit /
    rollback would allow them to realize an 'oopsie' and commit rollback.
    Ultimately, we're trying to emulate an Oracle client like sql plus or pl/sql
    developer

    jppa Guest

  4. #4

    Default Re: is this possible - cftransaction

    Hi

    Using the cftransaction, either we can commit all the transactions or rollback
    all the transactions. we can't do any checking in this for the user
    authentication. if you are checking it in the oracle then check for the how
    records are inserted . if no records are inserted then rollback it.

    vkunirs Guest

  5. #5

    Default Re: is this possible - cftransaction

    You can't do this using cftransaction. The beginning and end cftransaction tags
    have to be
    in one template, so the transaction completes when it's posted. You can't
    simply resubmit
    and rollback something that was commited on the previous post.

    OldCFer Guest

Similar Threads

  1. cftransaction
    By mjwjal in forum Coldfusion Database Access
    Replies: 17
    Last Post: November 6th, 03:45 PM
  2. Error with cftransaction
    By gusvok in forum Macromedia ColdFusion
    Replies: 0
    Last Post: April 6th, 09:10 PM
  3. using cftransaction with queries
    By Mattastic in forum Coldfusion - Getting Started
    Replies: 3
    Last Post: March 21st, 04:32 AM
  4. CFTRANSACTION w/ ROLLBACK
    By akosz in forum Macromedia ColdFusion
    Replies: 6
    Last Post: March 7th, 08:37 PM
  5. cftransaction question
    By Netopole in forum Macromedia ColdFusion
    Replies: 2
    Last Post: February 22nd, 04:19 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