0 Replies Latest reply on Jan 4, 2013 7:01 AM by webjoenet

    load "xml" from the mysql-database

    webjoenet

      hi

       

      I will summarize a part of designing a website that will start making ...

       

       

      I want to upload a file "xml" database mysql

        and view it in a web browser. (will be many files, tens, hundreds, thousands ...) they Sarong obiviamente saved by categories and also view them by category.

       

       

      file

      http://www.bahia.alphimedia.com/music.xml

       

       

       

       

      was trying to do too flash but gave error and visualized the file so muddled,

      for much that has researched,

      I think this type of file will have to be viewing it from the flex

       

       

      wanted you to show me more experience the better way to view this content for me to initiate this project, suffice a simple example of how to do it I'd turn around with the rest

       

      Thanks for now

      ______________

      I'm trying to load this file

      by the data service Flash Builder 4.6 and I'm not getting,

      component which would be appropriate to carry it

       

       

      <?xml version="1.1" encoding="UTF-8" standalone="no"?>
      <!DOCTYPE score-timewise PUBLIC "-//Recordare//DTD MusicXML 1.0 Timewise//EN" "http://www.musicxml.org/dtds/timewise.dtd">
      
      
      <score-partwise>
                <work>
                          <work-title>For the love of god</work-title>
                </work>
                <identification>
                          <creator type="composer">Steve Vai</creator>
                          <creator type="artist">Steve Vai</creator>
                          <creator type="tab">Fernando  MSN: lonjepiano@hotmail.com mail: rudess@gmail.com</creator>
                          <encoding>
                                    <software>Guitar Pro 5</software>
                                    <encoding-description>MusicXML 1.0</encoding-description>
                          </encoding>
                          <miscellaneous>
                                    <miscellaneous-field name="notice">Drum track was taken from another tab, guitar track was made from 0 by me                              </miscellaneous-field>
                          </miscellaneous>
                </identification>
                <part-list>
                          <score-part id="P1">
                                    <part-name>Vai</part-name>
                                    <score-instrument id="P1-I1">
                                              <instrument-name></instrument-name>
                                    </score-instrument>
                                    <midi-instrument id="P1-I1">
                                                        <midi-channel>1</midi-channel>
                                                        <midi-program>29</midi-program>
                                    </midi-instrument>
                          </score-part>
                          <score-part id="P2">
                                    <part-name>Sitar</part-name>
                                    <score-instrument id="P2-I2">
                                              <instrument-name></instrument-name>
                                    </score-instrument>
                                    <midi-instrument id="P2-I2">
                                                        <midi-channel>3</midi-channel>
                                                        <midi-program>104</midi-program>
                                    </midi-instrument>
                          </score-part>
                          <score-part id="P3">
                                    <part-name>Drums</part-name>
                                    <score-instrument id="P3-I3">
                                              <instrument-name></instrument-name>
                                    </score-instrument>
                                    <midi-instrument id="P3-I3">
                                                        <midi-channel>10</midi-channel>
                                                        <midi-program>0</midi-program>
                                    </midi-instrument>
                          </score-part>
                          <score-part id="P4">
                                    <part-name>Clean</part-name>
                                    <score-instrument id="P4-I4">
                                              <instrument-name></instrument-name>
                                    </score-instrument>
                                    <midi-instrument id="P4-I4">
                                                        <midi-channel>5</midi-channel>
                                                        <midi-program>27</midi-program>
                                    </midi-instrument>
                          </score-part>
                </part-list>
                <measure number="1">
                          <part id="P1">
                                    <attributes>
                                              <divisions>3</divisions>
                                              <key>
                                                        <fifths>0</fifths>
                                                        <mode>major</mode>
                                              </key>
                                              <time>
                                                        <beats>4</beats>
                                                        <beat-type>4</beat-type>
                                              </time>
                                              <clef>
                                                        <sign>TAB</sign>
                                                        <line>5</line>
                                              </clef>
                                              <staff-details>
                                                        <staff-lines>7</staff-lines>
                                                        <staff-tuning line ="7">
                                                                  <tuning-step>E</tuning-step>
                                                                  <tuning-octave>5</tuning-octave>
                                                        </staff-tuning>
                                                        <staff-tuning line ="6">
                                                                  <tuning-step>B</tuning-step>
                                                                  <tuning-octave>4</tuning-octave>
                                                        </staff-tuning>
                                                        <staff-tuning line ="5">
                                                                  <tuning-step>G</tuning-step>
                                                                  <tuning-octave>4</tuning-octave>
                                                        </staff-tuning>
                                                        <staff-tuning line ="4">
                                                                  <tuning-step>D</tuning-step>
                                                                  <tuning-octave>4</tuning-octave>
                                                        </staff-tuning>
                                                        <staff-tuning line ="3">
                                                                  <tuning-step>A</tuning-step>
                                                                  <tuning-octave>3</tuning-octave>
                                                        </staff-tuning>
                                                        <staff-tuning line ="2">
                                                                  <tuning-step>E</tuning-step>
                                                                  <tuning-octave>3</tuning-octave>
                                                        </staff-tuning>
                                                        <staff-tuning line ="1">
                                                                  <tuning-step>B</tuning-step>
                                                                  <tuning-octave>2</tuning-octave>
                                                        </staff-tuning>
                                              </staff-details>
                                    </attributes>
                                    <sound pan="8" tempo="100"/>
                                    <barline location="left">
                                              <bar-style>heavy-light</bar-style>
                                    </barline>
                                    <note>
                                              <rest/>
                                              <duration>6</duration>
                                              <voice>1</voice>
                                              <type>half</type>
                                    </note>
                                    <note>
                                              <grace slash="yes" steal-time-previous="6%" />
                                              <pitch>
                                                        <step>A</step>
                                                        <octave>4</octave>
                                              </pitch>
                                              <voice>1</voice>
                                              <type>32th</type>
                                              <notations>
                                                        <slide type="start"/>
                                                        <technical>
                                                                  <string>4</string>
                                                                  <fret>7</fret>
                                                        </technical>
                                              </notations>
                                    </note>
                                    <note>
                                              <pitch>
                                                        <step>B</step>
                                                        <octave>4</octave>
                                              </pitch>
                                              <duration>2</duration>
                                              <voice>1</voice>
                                              <type>quarter</type>
                                              <time-modification>
                                                        <actual-notes>3</actual-notes>
                                                        <normal-notes>2</normal-notes>
                                              </time-modification>
                                              <notations>
                                                        <dynamics>
                                                                  <f/>
                                                        </dynamics>
                                                        <slide type="stop"/>
                                                        <technical>
                                                                  <string>4</string>
                                                                  <fret>9</fret>
                                                        </technical>
                                              </notations>
                                    </note>
                                    <note>
                                              <pitch>
                                                        <step>D</step>
                                                        <octave>5</octave>
                                              </pitch>
                                              <duration>2</duration>
                                              <voice>1</voice>
                                              <type>quarter</type>
                                              <time-modification>
                                                        <actual-notes>3</actual-notes>
                                                        <normal-notes>2</normal-notes>
                                              </time-modification>
                                              <notations>
                                                        <dynamics>
                                                                  <f/>
                                                        </dynamics>
                                                        <technical>
                                                                  <string>3</string>
                                                                  <fret>7</fret>
                                                        </technical>
                                              </notations>
                                    </note>
                                    <note>
                                              <pitch>
                                                        <step>A</step>
                                                        <octave>5</octave>
                                              </pitch>
                                              <duration>2</duration>
                                              <voice>1</voice>
                                              <type>quarter</type>
                                              <time-modification>
                                                        <actual-notes>3</actual-notes>
                                                        <normal-notes>2</normal-notes>
                                              </time-modification>
                                              <notations>
                                                        <dynamics>
                                                                  <f/>
                                                        </dynamics>
                                                        <technical>
                                                                  <string>2</string>
                                                                  <fret>10</fret>
                                                        </technical>
                                              </notations>
                                    </note>
                          </part>
                          <part id="P2">
                                    <attributes>
                                              <divisions>2</divisions>
                                              <key>
                                                        <fifths>0</fifths>
                                                        <mode>major</mode>
                                              </key>
                                              <time>
                                                        <beats>4</beats>
                                                        <beat-type>4</beat-type>
                                              </time>
                                              <clef>
                                                        <sign>TAB</sign>
                                                        <line>5</line>
                                              </clef>
                                              <staff-details>
                                                        <staff-lines>6</staff-lines>
                                                        <staff-tuning line ="6">
                                                                  <tuning-step>E</tuning-step>
                                                                  <tuning-octave>5</tuning-octave>
                                                        </staff-tuning>
                                                        <staff-tuning line ="5">
                                                                  <tuning-step>B</tuning-step>
                                                                  <tuning-octave>4</tuning-octave>
                                                        </staff-tuning>
                                                        <staff-tuning line ="4">
                                                                  <tuning-step>G</tuning-step>
                                                                  <tuning-octave>4</tuning-octave>
                                                        </staff-tuning>
                                                        <staff-tuning line ="3">
                                                                  <tuning-step>D</tuning-step>
                                                                  <tuning-octave>4</tuning-octave>
                                                        </staff-tuning>
                                                        <staff-tuning line ="2">
                                                                  <tuning-step>A</tuning-step>
                                                                  <tuning-octave>3</tuning-octave>
                                                        </staff-tuning>
                                                        <staff-tuning line ="1">
                                                                  <tuning-step>E</tuning-step>
                                                                  <tuning-octave>3</tuning-octave>
                                                        </staff-tuning>
                                              </staff-details>
                                    </attributes>
                                    <sound pan="6"/>
                                    <barline location="left">
                                              <bar-style>heavy-light</bar-style>
                                    </barline>
                          </part>
                          <part id="P3">
                                    <attributes>
                                              <divisions>1</divisions>
                                              <key>
                                                        <fifths>0</fifths>
                                                        <mode>major</mode>
                                              </key>
                                              <time>
                                                        <beats>4</beats>
                                                        <beat-type>4</beat-type>
                                              </time>
                                              <clef>
                                                        <sign>percussion</sign>
                                                        <line>5</line>
                                              </clef>
                                              <staff-details>
                                                        <staff-lines>6</staff-lines>
                                                        <staff-tuning line ="6">
                                                                  <tuning-step>C</tuning-step>
                                                                  <tuning-octave>0</tuning-octave>
                                                        </staff-tuning>
                                                        <staff-tuning line ="5">
                                                                  <tuning-step>C</tuning-step>
                                                                  <tuning-octave>0</tuning-octave>
                                                        </staff-tuning>
                                                        <staff-tuning line ="4">
                                                                  <tuning-step>C</tuning-step>
                                                                  <tuning-octave>0</tuning-octave>
                                                        </staff-tuning>
                                                        <staff-tuning line ="3">
                                                                  <tuning-step>C</tuning-step>
                                                                  <tuning-octave>0</tuning-octave>
                                                        </staff-tuning>
                                                        <staff-tuning line ="2">
                                                                  <tuning-step>C</tuning-step>
                                                                  <tuning-octave>0</tuning-octave>
                                                        </staff-tuning>
                                                        <staff-tuning line ="1">
                                                                  <tuning-step>C</tuning-step>
                                                                  <tuning-octave>0</tuning-octave>
                                                        </staff-tuning>
                                              </staff-details>
                                    </attributes>
                                    <sound pan="8"/>
                                    <barline location="left">
                                              <bar-style>heavy-light</bar-style>
                                    </barline>
                          </part>
                          <part id="P4">
                                    <attributes>
                                              <divisions>1</divisions>
                                              <key>
                                                        <fifths>0</fifths>
                                                        <mode>major</mode>
                                              </key>
                                              <time>
                                                        <beats>4</beats>
                                                        <beat-type>4</beat-type>
                                              </time>
                                              <clef>
                                                        <sign>TAB</sign>
                                                        <line>5</line>
                                              </clef>
                                              <staff-details>
                                                        <staff-lines>6</staff-lines>
                                                        <staff-tuning line ="6">
                                                                  <tuning-step>E</tuning-step>
                                                                  <tuning-octave>5</tuning-octave>
                                                        </staff-tuning>
                                                        <staff-tuning line ="5">
                                                                  <tuning-step>B</tuning-step>
                                                                  <tuning-octave>4</tuning-octave>
                                                        </staff-tuning>
                                                        <staff-tuning line ="4">
                                                                  <tuning-step>G</tuning-step>
                                                                  <tuning-octave>4</tuning-octave>
                                                        </staff-tuning>
                                                        <staff-tuning line ="3">
                                                                  <tuning-step>D</tuning-step>
                                                                  <tuning-octave>4</tuning-octave>
                                                        </staff-tuning>
                                                        <staff-tuning line ="2">
                                                                  <tuning-step>A</tuning-step>
                                                                  <tuning-octave>3</tuning-octave>
                                                        </staff-tuning>
                                                        <staff-tuning line ="1">
                                                                  <tuning-step>E</tuning-step>
                                                                  <tuning-octave>3</tuning-octave>
                                                        </staff-tuning>
                                              </staff-details>
                                    </attributes>
                                    <sound pan="8"/>
                                    <barline location="left">
                                              <bar-style>heavy-light</bar-style>
                                    </barline>
                                    <note>
                                              <rest/>
                                              <duration>4</duration>
                                              <voice>1</voice>
                                              <type>whole</type>
                                    </note>
                          </part>
                </measure>
                </score-partwise>
      
      
      
      
      
      
      
      

       

      but it is much bigger than this


      it causes an error in score-partwise

       

      Sem título.jpg