Topic: cftransaction


master    -- 10-04-2002 @ 11:09 AM
  I am not be able to commit an update query in a Oracle database. I have used <cftransaction> as the code below, but it is not commiting.  I also tried to use a query with update line command, instead of cfupdate.
Can you help me please? Tks, Master.
CFTRANSACTION ACTION="BEGIN"
cfupdate datasource="dgpbd" dbtype="odbc"  tablename="desf"
formfields= "#media#,'#typo#', '#year#', '#sem#'"
CFTRANSACTION ACTION="COMMIT" /
/cftransaction
cfif commit EQ "Yes"

This message was edited by master on 10-4-02 @ 11:11 AM


Webmaster    -- 10-04-2002 @ 3:44 PM
  Try this:

CFTRANSACTION ACTION="BEGIN"
cfupdate datasource="dgpbd" dbtype="odbc"  tablename="desf"
formfields= "media, typo, year, sem"
CFTRANSACTION ACTION="COMMIT" /
/cftransaction
cfif commit EQ "Yes"

I simply removes the pounts etc for your formfields, those aren't needed. If it doesn't work, let me know and we'll find you anothe solution! Smile

Thanks,
Pablo Varando
EasyCFM.COM, LLC.


EasyCFM.COM ColdFusion Forums : http://archive.easycfm.com/forums
Topic: http://archive.easycfm.com/forums/viewmessages.cfm?Forum=12&Topic=22