Spectra 1.5.3, cftransaction and security tags

[Anthony Dimino-2]

Hi,

I have this cfatransaction block , the firts datasource is ="#request.cfa.objectstore.dsn#" , but cfa_workflowexecute use a second
datasource in cfa_workflowxecute.cfm...

And it's a known bugs, in Spectra 1.5.3 :
Macromedia Spectra 1.5.3 uses a database connection within ColdFusion MX to call the security tags. Because of this, the cftransaction tag may fail with multiple database errors. To work around this issue, you can directly create queries to the database for cftransaction calls.

But I don't understand "create queries to the database for cftransaction calls", i dont't want to re-write all the spectra security tags!

I have to use this 2 differents datasources aname (CODB datasource and security datasource) both have differents user / pwd.
-->In my Company security rules,  I can not use the same datasource name.

Thanks for your help.


<cftransaction>
                 
                 <cfa_contentobjectdata datasource="#request.cfa.objectstore.dsn#" objectid="#stObjects[taskID].objectid#">
                  <cfa_contentobjectproperty name="username" value="#ProfileUserTask#">
                  <cfa_contentobjectproperty name="Label" value="#stObject3.label#">
                  <cfa_contentobjectproperty name="Description" value="#stObject3.description#">
                  <cfa_contentobjectproperty name="parentSpecID" value="#ProfileTaskId#">
                  <cfa_contentobjectproperty name="dateBegin" value="">
                  <cfa_contentobjectproperty name="dateEnd" value="">
                  <cfa_contentobjectproperty name="scheduleEnd" value="">
                  <cfa_contentobjectproperty name="hasNotified" value=0>
                 </cfa_contentobjectdata>

                 <cfoutput>BAP changement pour #stObjects[taskID].objectid#<br></cfoutput>

                 <!--- Verification de coherence : la tache doit appartenir au workflow --->
                 <cfif structKeyExists(stObject2.STTASKSHAVENOTIFIED,stObjects[taskID].objectid)>
                  <!--- On remet la tache a non notifie --->
                  <cfset stObject2.STTASKSHAVENOTIFIED[stObjects[taskID].objectid] = 0>
                  <!--- On met a jour le workflow --->
                  <cfa_contentobjectdata datasource="#request.cfa.objectstore.dsn#" objectid="#stObjects[taskID].workflowid#">
                  <cfa_contentobjectproperty name="description" value="Transmis au mandataire">
                  <cfa_contentobjectproperty name="STTASKSHAVENOTIFIED" value="#stObject2.STTASKSHAVENOTIFIED#">
                  </cfa_contentobjectdata>
                  <!-- Rafraichissement du worflow -->
                  <cfa_workflowexecute
                    datasource="#request.cfa.objectstore.dsn#"
                  workflowid="#stObjects[taskID].workflowid#">
                 </cfif>
                 
<!--- fin transaction --->
                 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:17:5664
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/17
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:17
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.17
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54