XML Table Export Forum :: Returning Blank from Cold Fusion
This thread was displayed: 615 times
Starting with 17th May 2007, Adobe Systems will stop offering support for any version of the discontinued InterAKT products. As a result, we will not answer to new support incidents starting with May 17th, 2007. Pending support incidents will still be followed in order to be closed. The product forums will remain open and be transformed in user-to-user forums. The general forums will be made read-only and not allow new posts or comments.
For more information about the affected products visit: www.interaktonline.com/Support/
jde
01-09-2006 11:48:03 GMT +2
|
I have a simple CF recordset that will return about 9 results and I wish to export them so I can use them in an RIA. Here is my code:
<cfinclude template="../includes/xml/XML.cfm">
<cfquery datasource="ratebox" name="Recordset1">
SELECT entry, PageName
FROM PageText
WHERE pagetype = 'x'
ORDER BY pageorder ASC
</cfquery>
<cfscript>
// Begin XMLExport Recordset1
xmlExport_Recordset1 = XML_CreateObject("XML_Export");
xmlExport_Recordset1.init();
xmlExport_Recordset1.setRecordset(Recordset1);
xmlExport_Recordset1.addColumn("entry", "STRING_TYPE", "entry");
xmlExport_Recordset1.addColumn("PageName", "STRING_TYPE", "pagename");
xmlExport_Recordset1.setFilename("PageMenu.xml");
xmlExport_Recordset1.setMaxRecords("ALL");
xmlExport_Recordset1.setXMLEncoding("UTF-8");
xmlExport_Recordset1.setXMLFormat("NODES");
xmlExport_Recordset1.Execute("VALUE", "1");
// End XMLExport Recordset1
</cfscript>
The recordset definitely returns records but the XML is completely blank. I have uploaded it to
http://www.theratebox.com/rpc/testdata2.cfm
The XML document is compeletly blank.
I have used this in PHP with no such problems!
Please help! Thanks!
|
|
|
Florin CARLIG[InterAKT]  01-13-2006 12:39:08 GMT +2
|
Hello Jim,
I've just tried your URL and it's not completely blank - the records exist and are shown, but at the very end of the file.
Try to enable Trim whitespaces on your Coldfusion server and let us know if that fixes the problems.
Regards,
Florin CARLIG
|
|
|
jde
01-13-2006 13:39:23 GMT +2
|
I have looked at the CF server - this is a hosted dite - and there is no ability to turn off whitespaces. I have looked at my own on localhost (I am running Cold Fusion MX and there is no appropriate setting) If you look at the CF output it seems place a load of tabs etc. at the beginning.
|
|
|
jde
01-13-2006 15:06:35 GMT +2
|
Further to my reply I have uploaded the following to the site:
<cfquery name="Recordset1" datasource="ratebox">
SELECT entry, PageName
FROM PageText
WHERE pagetype = 'x'
ORDER BY pageorder ASC
</cfquery>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<cfoutput query="Recordset1">
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td>#Recordset1.entry#</td>
<td>#Recordset1.PageName#</td>
</tr>
</table>
</cfoutput>
</body>
</html>
which shows what is in the table. This can be accessed via http://www.ratebox.com/rpb/testdata3.cfm
|
|
|
Florin CARLIG[InterAKT] 01-17-2006 11:29:23 GMT +2
|
|
|
|
jde
01-17-2006 16:37:32 GMT +2
|
Sorry if I did not make myself plain.
The testdata2.cfm is the page that should be returning the XML. The testdata3 runs the same query but outputs the results to the screen.
|
|
|
Florin CARLIG[InterAKT] 01-20-2006 19:40:38 GMT +2
|
Hello Jim,
I'm sorry about the late reply. In order to investigate this problem more thoroughly, we will need to connect to your FTP server and try to debug this live.
Please provide the FTP details private.
Regards,
Florin CARLIG
|
|
|
