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 --->
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210944
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
