3 Replies Latest reply on Feb 6, 2007 9:14 AM by emmim44

    XML dont work

    emmim44 Level 1
      Hi all. I am trying to back up a desired table in my oracle db using XML, but I am getting this err:

      [TXMESPERMONTH: coldfusion.sql.QueryColumn@170b890] [NEXREQ: coldfusion.sql.QueryColumn@16502fc] [NEXPERMONTH: coldfusion.sql.QueryColumn@a70acd] [BBREQ: coldfusion.sql.QueryColumn@b63dfe] [VOBBREQ: coldfusion.sql.QueryColumn@a01711] [BBVOPERMONTH: coldfusion.sql.QueryColumn@4a6ccc] [PAGREQ: coldfusion.sql.QueryColumn@2cd5a3] [WDEVICE: coldfusion.sql.QueryColumn@17dfcf1] [WIRELESSNUMB: coldfusion.sql.QueryColumn@697087] [WORKREQ: coldfusion.sql.QueryColumn@5acf13] [DEPTOPREQ: coldfusion.sql.QueryColumn@1d1282d] [NORMOFFREQ: coldfusion.sql.QueryColumn@a4b9da] [IMMRESREQ: coldfusion.sql.QueryColumn@a5d82a] [IMMCOMREQ: coldfusion.sql.QueryColumn@12e72d] [ROUTDIFF: coldfusion.sql.QueryColumn@10747b4] ] is not indexable by 1.0


      The error occurred in C:\CFusionMX\wwwroot\Denemeler\KaraTahta\xmLTest.cfm: line 35

      33 :
      34 : <cfloop from="1" to="#in.recordcount#" index="i">
      35 : <#getTbName#> <#column_ar #><cfset content = in >#content#</#column_ar#> </#getTbName#>
      36 : </cfloop>
      37 :






      ---------------The Code-------------------------------
      <cfquery name="in0" datasource="#FormVector#">
      SELECT TABLE_NAME FROM USER_TABLES
      </cfquery>

      <cfset getTbName=valuelist(in0.table_name)>
      <cfset getTbName=listgetat(getTbName,9)>


      <cfquery name="in" datasource="#FormVector#">
      select * from <cfoutput>#getTbName#</cfoutput>
      </cfquery>




      <cfset column_ar = listToArray(in.columnlist)>
      <cfdump var="#column_ar#">


      <cfoutput>
      <cfsavecontent variable="xml_output">
      <?xml version="1.0" encoding="UTF-8" ?>


      <cfloop from="1" to="#in.recordcount#" index="i">
      <#getTbName#>
      <#column_ar #>
      <cfset content = in
      >#content#
      </#column_ar
      #>
      </#getTbName#>
      </cfloop>




      </cfsavecontent>
      </cfoutput>

      <cffile action="Write" file="c:\path_to_my_file.xml" output="#trim(xml_output)#">