Spectra 1.5.3, cftransaction and security tags
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 cfoutputBAP 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
WDDX from CF 5 to CF MX 6.1
hi liere, It works! Thanks so much for your help. Yes, there are other developers still working with spectra! hi anthony, we faced the same problems when migrating from spectra1.5. 1/oracle8i/cf5 to spectra1.5.3/oracle8i/CFMX for us the culprits are control characters inside a CF5 wddx paket, which CFMX cannot deserialize anymore, to see if it is the same for you, try this snippet we just do a replace in the wddx before deserializing it, then CFMX should do it - get the wddx from anywhere (CF5 style) - cfset cleanWddxpack = ReReplace(dirtyWddxpack, [[:cntrl:]], , ALL) - deserialize the wddx with the tag of your choice we have ready a routine which is able to patch a whole DB, so that CFMX can handle former CF5 wddx pakets just let me know if this did the trick for you besides: good to hear that there are other developers still working with spectra, in the moment we are migrating our apps (we do a web content management system with spectra, 230 spectra apps) to CFMX, the main problems we are facing, have to do with the CLOB datatype in oracle and poor performance on any table containing CLOB´s, there´s not one driver available in the moment which does a good job there, but it looks like we solved this problems in the last few days, we banned the CLOB and use LONG instead, the performance is incredible now, we never see our apps ran like this before, ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206611 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
WDDX from CF 5 to CF MX 6.1
Hi We are migrating from CF 5 / Spectra 1.5.1/ Oracle 8 to CF MX 6.1 / Spectra 1.5.3 /Oracle 9i We are a french company, so we use a lot accent (é,è,à,...etc) , on CF5 this accent (extended ASCII code) are coded like that in WDDX ; #xE9; for é , for instance. But in CF MX 6.1 , we can not use this WDDX (with WDDX2CFML tag fir instance), we have the following error messages: WDDX parser error For the existing WDDX; If we put this header before the WDDX : ?xml version=1.0 encoding=ISO-8859-1? , it works... I can write a coldfusion batch to insert in DB this new header for all my existing WDDX but i'm trying to search a better solution, without lot of development :( For the new WDDX, using CF MX 6.1, no problem If i change JVM parmaters with dfile.encoding = iso-8859-1 The problem is only for the prevoius WDDX used in CF 5... What's the best way using unicode ?utf-8? I'm lost... Can someone helps me? Thanks. Anthony This e-mail message, including any attachments transmitted with it, is CONFIDENTIAL and may contain legally privileged information. This message is intended solely for the use of the individual or entity to whom it is addressed. If you are not the intended recipient you should not read, copy, distribute, disclose or otherwise use this information. If you have received this message in error, please notify us immediately and delete it from your system. The integrity and security of this message cannot be guaranteed and it may be subject to data corruption and unauthorised amendment, for which we accept no liability. Euroclear reserves the right to retain email messages on its systems and to the extent and under circumstances permitted by applicable law, to monitor and intercept email messages to and from its systems. Euroclear is the marketing name for the Euroclear System, Euroclear plc, Euroclear SA/NV and their affiliates. http://www.euroclear.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206499 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