Hi
I'm grappling with some xml
I want to export data from my database in an xml file but I only get the
1st record
I'm doing this: (but I can't see how to loop over each record)
<cfquery name="get_data" datasource="#request.main_dsn#" dbtype="ODBC">
SELECT tblWEBSTOCKLEVEL.CustomerID, tblWEBSTOCKLEVEL.ProductCode,
tblWEBSTOCKLEVEL.ProductDescription, tblWEBSTOCKLEVEL.StockLevel
FROM tblWEBSTOCKLEVEL
WHERE (((tblWEBSTOCKLEVEL.CustomerID)=1));
</cfquery>
<!--- create a temporary variable to hold XML document --->
<cfset tempxml="<?xml version ""1.0""?>
<stock_levels>
<CustomerID>#trim("#XMLFormat(get_data.CustomerID)#")#</CustomerID>
<stock_details>
<cfloop query=""get_data"">
<item
ProductCode=""#trim("#XMLFormat(get_data.ProductCode)#")#""
ProductDescription=""#trim("#XMLFormat(get_data.ProductDescription)#")#""
StockLevel=""#trim("#XMLFormat(get_data.StockLevel)#")#""/>
</cfloop>
</stock_details>
</stock_levels>
">
Can anyone help me please with the looping needed to get each record rather
than just the first one.
Many thanks
Seamus
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
