This content has been marked as final.
Show 8 replies
-
1. Re: nl2br how to do this displaying the XML from the php created by the Export Recordset to XML behaviour in Adobe DT?
Donald Booth Mar 31, 2008 7:20 PM (in response to Eirehotspur)Have you seen this sample?
http://labs.adobe.com/technologies/spry/samples/data_region/XMLDataSetStringHandlingSample .html -
2. nl2br how to do this displaying the XML from the php created by the Export Recordset to XML behaviour in Adobe DT?
Eirehotspur Apr 1, 2008 1:56 AM (in response to Donald Booth)Thanks for that swift reply and pointer Donald.
from a simple nl2br + ()s to format to a full page of gibberish.....God I am going to need a flask of tea and patience for this part.
I will work through it though.
Thanks again. -
3. Re: nl2br how to do this displaying the XML from the php created by the Export Recordset to XML behaviour in Adobe DT?
Donald Booth Apr 1, 2008 7:55 AM (in response to Eirehotspur)Or you can post your page and we can better assist... -
4. nl2br how to do this displaying the XML from the php created by the Export Recordset to XML behaviour in Adobe DT?
Eirehotspur Apr 14, 2008 1:18 PM (in response to Donald Booth)http://www.sites.ferbane.tv/rosemount.ie/export_spry_sample.php
This is the page as a result of the Export recordset as XML from
http://www.sites.ferbane.tv/rosemount.ie/export.php
What I would like to do is
Create a MySQL database for FLV videos
export to an xml file
These XML files would provide video lists to be used in FLV Players.
Lisa Larsons book leaves this out as does every website I have ever googled.
Can someone at Adobe help out thousands of people I am sure would benifit of a tutorial in the video section of the adobe website that lays out A-Z how to do this.....can you suggest this strongly to your head honcos there.
Thanks -
5. Re: nl2br how to do this displaying the XML from the php created by the Export Recordset to XML behaviour in Adobe DT?
Arnout Kazemier Apr 14, 2008 1:25 PM (in response to Eirehotspur)Your export doesnt wrap your HTML content in <[[CDATA tag which are required to display the content as HTML
Wrapping it in cdata tags, and setting the columntype as html would fix your problems. -
6. Re: nl2br how to do this displaying the XML from the php created by the Export Recordset to XML behaviour in Adobe DT?
Eirehotspur May 13, 2008 2:29 AM (in response to Arnout Kazemier)Sorry for rehashing this again but was so frustratd I left it for a while and am back trying to figure it againn
Tried what you said and tried these two things using Cdata tags in two differnt places...neither works.
<!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" xmlns:spry=" http://ns.adobe.com/spry">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<script src="SpryAssets/xpath.js" type="text/javascript"></script>
<script src="SpryAssets/SpryData.js" type="text/javascript"></script>
<script type="text/javascript">
<![CDATA[
<!--
var ds1 = new Spry.Data.XMLDataSet("export.php", "rosemount/row");
//-->
]]>
</script>
</head>
<body>
<div spry:region="ds1">
<table>
<tr>
<th>Id_page</th>
<th>Title</th>
<th>Body</th>
</tr>
<tr spry:repeat="ds1">
<td>{id_page}</td>
<td>{title}</td>
<td>{body}</td>
</tr>
</table>
</div>
</body>
</html>
------------------------------------------------------------------------------------------ ----------------------------------------------
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<script src="SpryAssets/xpath.js" type="text/javascript"></script>
<script src="SpryAssets/SpryData.js" type="text/javascript"></script>
<script type="text/javascript">
<!--
var ds1 = new Spry.Data.XMLDataSet("export.php", "rosemount/row");
//-->
</script>
</head>
<body>
<![CDATA[
<div spry:region="ds1">
<table>
<tr>
<th>Id_page</th>
<th>Title</th>
<th>Body</th>
</tr>
<tr spry:repeat="ds1">
<td>{id_page}</td>
<td>{title}</td>
<td>{body}</td>
</tr>
</table>
]]>
</div>
</body> -
7. Re: nl2br how to do this displaying the XML from the php created by the Export Recordset to XML behaviour in Adobe DT?
Arnout Kazemier May 13, 2008 5:54 AM (in response to Eirehotspur)Not the CDATA in your HTML but in your XML feed so your PHP export file should add the CDDATA
:) -
8. Re: nl2br how to do this displaying the XML from the php created by the Export Recordset to XML behaviour in Adobe DT?
Eirehotspur Jun 2, 2008 11:56 AM (in response to Arnout Kazemier)Just want to say thanks Donald for your replies.
Found a third party piece of software that exports xml from a mysql database to use in my flash files.
Also found that by inserting this line of code:
$Value = str_replace("\r\n", "\n", $Value);
It formats my text like the nl2br on ordinary php web pages.
So my search for a year to this solution is at an end.


