Skip to main content
A
Anonymous
April 20, 2007
Question

How to dynamically SAVE Recordset as XML?

  • April 20, 2007
  • 1 reply
  • 708 views
Does anyone know how to SAVE an exported recordset as a xml file on the server? (php MySQL)

I'm using the developer toolbox to 'export recordset as XML' and it loads the xml data dynamically, but it's slow. I'm hoping that there is a way i could have the xml file generated and saved on the server so that i dont' have to query the database every time.

I saw this article on how to do it, but i can't get it to work with the 'export recordset' feature
http://articles.techrepublic.com.com/5100-3513_11-6141415.html

any help is appreciated.
This topic has been closed for replies.

1 reply

N
Newsgroup_User
Inspiring
April 21, 2007
dz101 wrote:
> Does anyone know how to SAVE an exported recordset as a xml file on the server?
> (php MySQL)
>
> I'm using the developer toolbox to 'export recordset as XML' and it loads the
> xml data dynamically, but it's slow. I'm hoping that there is a way i could
> have the xml file generated and saved on the server so that i dont' have to
> query the database every time.

A very simple way of doing it is to load the PHP file that generates the
XML into a browser. Right-click and view the source code. Select the
source, copy it, and paste it into a new file. Save it as XML.

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
A
Anonymous
April 23, 2007
Let me clarify. Yes, i know that it can be done manually by saving the souce code as an xml file. What i'm looking for is a way for the XML file to be autimatically written to the server rather than dynamically generated because it seems to be painfully slow that way.

I know that in the previous versions of the InterAKT XML extenstion, there was an option to save xml as a file, but that seems to be gone in the Adobe version.

I'm trying to set up some Spry data that lists upcoming events and associated images. I'd like to be able to update that info in a database and have a new XML file generated upon update. That way, I could feed a static XML file into the spry regions rather than having to do an XML transformation request each time the page is requested.

Again, the XML transfomration is EXTREMELY slower than calling a static XML file, but i don't want to have to manually generate the XML file everytime i upate the database.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices