469,295 Members | 1,914 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,295 developers. It's quick & easy.

How to save XML files generated from the database

I wrote code to generate the XML file from Ms-Access database. Can anyone tell me how to Save the XML file..

Sadiq
Feb 27 '07 #1
7 3807
dorinbogdan
839 Expert 512MB
If the XML string is already created you just need to write it to a file.
(I think that MSAccess has the functions for file manipulation as for VB6).
Suposing that strXML contains your XML string and C:\mynewfile.xml is the destination, try:

Expand|Select|Wrap|Line Numbers
  1. Dim f As Integer
  2. f = Freefile
  3. Open "C:\mynewfile.xml" For Output As #f
  4. Print #f, strXML
  5. Close #f
Feb 27 '07 #2
dorinbogdan
839 Expert 512MB
Hi,
Did you succeed to solve the problem ?
If yes, please let me know, in order to close the thread.
Thanks,
Dorin.
Mar 21 '07 #3
hi
please can you tell how you wrote the xml files generated from a database?
i need to use a database access
thank you
Mar 22 '07 #4
dorinbogdan
839 Expert 512MB
What language are you using? VB, C#, Java...?
Mar 22 '07 #5
I would like to know how can we save the generated XML file...
On clicking the Submit button in a html file, the xml is generated from the DB2 database... I can see the xml file in a url like this http://192.168.100.74:3012/CICS/CWBA/CSCWKI2X/NEWPRO7W/NewProject7

I want to save this... how can i do that... some one please help....
Apr 18 '07 #6
dorinbogdan
839 Expert 512MB
Welcome to TheScripts TSDN....

From client-side you can save files on disk only using Internet Explorer (using FileSystemObject ActiveX), but Mozilla Firefox doesn't allow ActiveX.

However, for more Javascript help I recommend to post a question on the Javascript forum.

God bless you.
Dorin.
Apr 18 '07 #7
I am having the same problem. I have a php query that is accessing a database and then generating an XML file when the url is clicked. I want to save the XML if and have it constantly refreshing to keep the information up-to-date.

Thanks
Lucy
Jul 3 '07 #8

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

7 posts views Thread by joseph.inglis | last post: by
4 posts views Thread by sunilj20 | last post: by
2 posts views Thread by Giedrius | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Geralt96 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.