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)#">