www.webdeveloper.com
Results 1 to 5 of 5

Thread: Trying to Update image and text strings in XML using database

Hybrid View

  1. #1
    Join Date
    Mar 2011
    Posts
    2

    Trying to Update image and text strings in XML using database

    Can someone head me in the right direction? I just can't get a clear answer for this , I am sure, ver simple task .I have created a database with images, text strings and links and I want to insert certain cells into an xml file I have that is used in an image flipper of sorts. For example when I automatically update the database I want the xml file to show the new images text and links.

    First I am calling image then url and then finally custom text
    Any help would be greatly appreciated.

  2. #2
    Join Date
    Dec 2002
    Location
    St. Louis, MO, USA
    Posts
    1,582
    Maybe I'm not understanding exactly what you are asking for. But from what I've read of your question, it seems to me that you are making an extra unnecessary step, extra work for what can be done directly from the database.

    ^_^

  3. #3
    Join Date
    Mar 2011
    Posts
    2
    What I am trying to accomplish is updating a flash file which utilizes an xml file. The images and text and links are called from this xml file.My database is automatically updated with new info regularly and I want this to reflect in my flash file.

  4. #4
    Join Date
    Jan 2003
    Location
    Dundee, Scotland
    Posts
    1,367
    Hi,

    here is link to importing and exporting MySQL database/tables as XML.

    http://dev.mysql.com/tech-resources/...-5.1-exporting



    regards

    Ribs
    ----------------------------------

  5. #5
    Join Date
    Jul 2010
    Location
    /ramdisk/
    Posts
    865
    If you're using MS-SQL-S you can use

    with CTE as (
    select all your data ...
    )

    (select ...
    .... ... .... ...
    FOR XML [strict | auto | PATH('foobar')], [TYPE], [ELEMENTS]
    ) as tagbaz

    FOR XML PATH('root'), TYPE

    Works like a charm with common table expressions + all select sub-queries and no FROM clause. Not the most efficient thing in the world, but it's nice and easy once you understand the FOR XML syntax. You'll have to be a sub-query guru to get the data exactly how you want it-

    it can be an enormous hassle if your XML document is not structured in a hierarchical way. *slaps coworker*
    I use (, ; : -) as I please- instead of learning the English language specification: I decided to learn Scheme and Java;

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles