EasyCFM.COM ColdFusion Forums / Coding Help! / cftransaction

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: cftransaction

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

master
10-04-2002 @ 11:09 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
New Member
Posts: 2
Joined: Oct 2002

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
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Administrator
Posts: 4542
Joined: Jan 2002

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.


Website Designed and Developed by Pablo Varando.