macromedia.coldfusion.getting_started
[Top] [All Lists]

XML help wanted

Subject: XML help wanted
From: "arunaumuc"
Date: Tue, 23 Dec 2008 19:47:07 +0000 UTC
Newsgroups: macromedia.coldfusion.getting_started

 wrote a code to generate the an .xml file. It doesnot work. Can any one find 
any mistake in the code.

 code:
 ===============================

 <cfquery datasource="Arunatest1" name="update">
 select * from emp where deptno=10
 </cfquery>

 <cfxml variable="POXML">
 <cfoutput>
 <Productrequested Name="Test" PODATE="#Dateformat(now(),"mm/dd/yyyy")#" 
Supplier="UMUC web apps" SupplierName="Aruna"></cfoutput> 
 <Itemdetails>
 <cfoutput query="Update">
 <TaID> #emplid# </TaID>
 <StuID> #deptno# </StuID>
 <SSAN> #Name# </SSAN>
 <Stu_Last> #City# </Stu_Last>
 </cfoutput>
 </Itemdetails>
 <Productrequested>
 </cfxml>

 <cfoutput>
 <cfset XMLTextForFile=ToString(POXML)>
 <cfset varFile="..\student.xml">
 <cffile action="write" file="#varFile#" output="#XMLTextForFile#">
 </cfoutput>





<Prev in Thread] Current Thread [Next in Thread>