is this possible - cftransaction

[jppa]

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

[vkunirs]

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?

[jppa]

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

[vkunirs]

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.

[OldCFer]

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.