0 Replies Latest reply on Oct 15, 2008 7:19 AM by Newsgroup_User

    Advice: SWF Dealing Large Data

    Level 7
      Dear Group,

      I am considering what is the best way to load and present a large number of
      records that is to be extracted from an SQL database, queried through Visual
      Basic and presented in Flash.

      Roughly speaking I will be extracting up to 15,000 records (member no, name
      and address). I plan to extract the data into 5 xml files (e.g. surnames A -
      D being one XML) for presentation in a member address book presentation. Can
      anyone offer me advice on the best way to present the information. I was
      considering loading the xml into a variable, looping through the nodes and
      showing 20 at a time. Each record would be a different movie clip using a
      variation on the code below as a starter. The "Person" movie clip would
      store the three details as listed above.

      var total = 15;

      button1.onRelease=function(){
      for(hiThere=1;hiThere<total;hiThere++){
      person.duplicateMovieClip("Person"+hiThere, hiThere);
      _root["person"+hiThere]._y=(hiThere*person._height)+15;
      _root["person"+hiThere]._x=100;
      }
      }

      Can anyone offer me some advice on the way they think it is the best to
      store and present this data?

      Thanks again.

      Alastair MacFarlane