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