Code Help Recordset values

Discussion in 'Javascript' started by ferky, Sep 10, 2004.

  1. ferky

    ferky Guest

    I have this code below when I asign strOldTkinit = strNewTkinit and
    then read the new value for the strNewTkinit from the recordset the
    strOldTkinit changes the value also. So when I run my comparison the
    values is always equal even though I read a new value from the
    recordset. Please help.


    function getRSXML(strSQL) {
    var adoCnn = null;
    var adoRst = null;
    var strRst = null;
    var strReturn = null;
    var i=0;
    var intPeriod = null;
    var intRange = null;
    var intPeriodTotal = null;
    var intRangeTotal = null;
    var intValue = 0;
    var strNewTkinit = "";
    var strOldTkinit = "";
    var strTkName = null;
    var strPeriod = 0;
    var numberTimes = 0;

    strReturn = "";

    try {
    adoCnn = new ActiveXObject("Webview.clsDatalayer");
    adoRst = new ActiveXObject("ADODB.Recordset");


    adoRst = adoCnn.Get_RecordSet(strSQL);
    //Get the <STATS> Info
    strReturn += '<STATS>';
    while ((adoRst.EOF == false) && (adoRst.BOF == false)) {


    strPeriod = adoRst(2);
    intValue = adoRst(5);
    if (strNewTkinit == strOldTkinit)
    {
    //strOldTkinit == strNewTkinit;
    //Same timekeeper perform calculations
    if (strPeriod == '0804'){ //should be a variable for current
    period
    intPeriod = intValue;
    }
    else{
    intRange += intValue;
    }


    }
    else // strOldTkinit == strNewTkinit;
    {

    if (numberTimes == 0)
    {
    numberTimes ++; // Never again
    //strOldTkinit = strNewTkinit;

    strTkName = adoRst(3) + ' ' + adoRst(4);

    //Same timekeeper perform calculations
    if (strPeriod == '0804'){ //should be a variable for current
    period
    intPeriod = intValue;
    }
    else{
    intRange += intValue;
    }

    }
    else
    {
    //If new timekeeper print current line
    i++;
    strReturn += '<z r=\"'+ i +'\" c1=\"'+ strOldTkinit +'\"
    c2=\"'+ strTkName +'\" c3=\"'+ intPeriod +'\" c4=\"'+ intRange +'\"
    />';

    //Calculate values for the <STATSFOOTER>
    intPeriodTotal += intPeriod;
    intRangeTotal += intRange;

    //strOldTkinit = strNewTkinit;
    trTkName = adoRst(3) + ' ' + adoRst(4);

    if (strPeriod == '0804'){ //should be a variable for current
    period
    intPeriod = intValue;
    }
    else{
    intRange += intValue;
    }

    }

    }


    adoRst.movenext;
    strOldTkinit = strNewTkinit;

    }

    i++;
    strReturn += '<z r=\"'+ i +'\" c1=\"'+ strOldTkinit +'\" c2=\"'+
    strTkName +'\" c3=\"'+ intPeriod +'\" c4=\"'+ intRange +'\" />';

    //Calculate values for the <STATSFOOTER>
    intPeriodTotal += intPeriod;
    intRangeTotal += intRange;

    strReturn += '</STATS><STATSFOOTER>';
    //<z r="397" c1="" c2="GRAND TOTAL" c3="-7169.50"
    c4="175414250.54" />
    strReturn += '<z r=\"'+ numberTimes +'\" c1=\"\" c2=\"GRAND TOTAL\"
    c3=\"'+ intPeriodTotal +'\" c4=\"'+ intRangeTotal +'\" />';
    strReturn += '</STATSFOOTER>';


    } catch (DBErr) {
    strReturn = "DBErr" + DBErr.message;
    } finally {
    try {
    adoRst.Close();
    } catch (CloseErr){}

    adoCnn = null;
    adoRst = null;
    strRst = null;
    }
    return strReturn;
    }
     
    ferky, Sep 10, 2004
    #1
    1. Advertising

  2. ferky

    kaeli Guest

    In article <>,
    enlightened us with...
    > I have this code below when I asign strOldTkinit = strNewTkinit and
    > then read the new value for the strNewTkinit from the recordset the
    > strOldTkinit changes the value also. So when I run my comparison the
    > values is always equal even though I read a new value from the
    > recordset. Please help.
    >
    >


    You've got a bunch of lines commented out, so I can't tell what you expect to
    run and what you may have forgotten you commented out.

    Trim this down to what actually executes, then re-post. You may find that you
    accidentally commented out something you meant to run.

    --
    --
    ~kaeli~
    When you choke a smurf, what color does it turn?
    http://www.ipwebdesign.net/wildAtHeart
    http://www.ipwebdesign.net/kaelisSpace
     
    kaeli, Sep 13, 2004
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Bill
    Replies:
    2
    Views:
    131
    Andrew Durstewitz
    Jul 9, 2003
  2. Hung Huynh
    Replies:
    8
    Views:
    330
    Bob Barrows
    Sep 24, 2003
  3. Fawke101

    Response.write RecordSet values

    Fawke101, Apr 21, 2004, in forum: ASP General
    Replies:
    4
    Views:
    360
    Ray at
    Apr 21, 2004
  4. Tim Pollard
    Replies:
    8
    Views:
    164
    Ray Costanzo [MVP]
    Dec 3, 2004
  5. Eddie

    Most popular values in a recordset

    Eddie, Dec 13, 2005, in forum: ASP General
    Replies:
    2
    Views:
    357
    Patrice
    Dec 13, 2005
Loading...

Share This Page