The setup...CFMX, Oracle 8, Solaris. The problem...retrieving WDDX packets created in CF 4.5
Code is attached. It takes a CF structure, CFML2WDDX packets it, inserts it into a CLOB column, retrieves it and WDDX2CFMLs it. If I run this on CFMX its fine. But, if I create the WDDX on CF 4.5 and then attempt to retrieve it on MX I get the following error: WDDX packet parse error at line 1, column -1. Illegal XML character: �.. It will work on a varchar2 column type, but not on long or Clob. Is this a bug? Code is below for your reference <cfwddx action="CFML2WDDX" input="#prefs#" output="dbprefs"> <cfquery datasource="blah" name="get_seq"> select temp.seq_temo.nextval as id from dual </cfquery> <cfquery datasource="blah" name="insert"> insert into temp.t_clob (clob_id,clob_data) values (#get_seq.id#, <cfqueryparam cfsqltype="CF_SQL_CLOB" value="#dbprefs#">) </cfquery> <cfquery datasource="blah" name="get"> select clob_data from temp.t_clob where clob_id = #get_seq.id# </cfquery> <cfwddx action="WDDX2CFML" input="#get.clob_data#" output="foo"> Jeff Britts Senior Software Engineer 781-372-1979 [EMAIL PROTECTED] ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
