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=89.70.17
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
