Thread: ideas needed

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2001
    Location
    valencia ,venezuela
    Posts
    13
    Rep Power
    0

    Question ideas needed


    WHAT I NEED IS THE FOLLOWING:
    I HAVE A DATABASE QUERY OF RECORDS DONE IN VBSCRIPT ON THE DATABASERECORDS THE FIELDS ARE THE SAME
    I DISPLAY THE TABLE USING DO LOOP WHILE NOT ORECORDSET.EOF SO EACH RECORD CONTAINS ONE SET OF
    COMPANY,COUNTRY,SALES I DO NOT KNOW JAVASCRIPT BUT AS I SEE THERE ARE SEVERAL INCONVINIENTS IN ORDER
    TO FILL THIS TABLE (HAS TO BE IN THIS ORDER IF NOT THE APPLET DOES NOT WORK)

    1- I SHOULD FILL THE COMPANY ROWS
    2- I SHOULD FILL THE COUNTRY ROWS
    3- THEN I SHOULD MAKE ANOTHER RUN FILLING SALES ON EACH COMPANY,COUNTRY

    MAYBE SHOULD PERFORM THREE QUERIES TO FILL THE TABLE
    OR BUILD A QUERY THAT BUILDS THE XML STRING
    OR PERFORM SEVERAL RUNS WHICH WILL SLOW DOWN THE PROCCESS SO THIS VALUES GO INTERACTIVELY WITH SEVERAL TYPES OF GRAFICS

    SOME ONE CAN GIVE ME SOME HELP AS I TOLD I HAVE NO IDEA OF SINTAX IN JAVA
    THANKS IN ADVANCE

    R.SOLER
    //THIS CODE FILL A TABLE USING RANDOM VALUES FOR THE EXAMPLES
    IMAGE GENERATED SO YOU CAN SEE IMPLEMENTATION


    ORIGINAL
    <script language="JavaScript">
    var rowLabels = new Array("Australia","Canada","Germany","Spain","France","England","Italy","Austria","Japan","USA","Oth er");
    var colLabels = new Array("Compaq","Dell","Gateway","IBM","HP","Micron","Other");
    function newContents()
    {
    var xml = "";
    xml += "<cols>Company";
    for(var i=0;i<colLabels.length;i++) xml += "<COL>"+colLabels[i]+"</>";
    xml += "</>";

    xml += "<rows>Country";
    for(var i=0;i<rowLabels.length;i++) xml += "<ROW>"+rowLabels[i]+"</>";
    xml += "</>";

    var msec = (new Date()).getMilliseconds();
    xml += "<DATA>Sales";
    for(var i=0;i<rowLabels.length;i++)
    for(var j=0;j<colLabels.length;j++)
    {
    msec = (msec*1103515245+12345)%100000000000000;
    xml += "<VALUE>"+(Math.round(msec/65536)%32768)/100.0+"</>";
    }
    xml += "</>";
    return "<xml>"+xml+"</>";
    }

    </SCRIPT>


    http://www.asotransporte.com/capture.gif
  2. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    539
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2001
    Location
    valencia ,venezuela
    Posts
    13
    Rep Power
    0

    sorry for this post i use asp


    Sorry for my post but as i am using asp maybe some charitatism could help me with jsp to perform the task
    R.Soler

IMN logo majestic logo threadwatch logo seochat tools logo