How to create array in Javascript?

Question

I have situation where I want to output two table columns from my query in array. Ideally I would like to output one ID_1 then second ID_2 and after I store all ID's in array I want to loop through that array to check if ID_1 is greater than 0 and if it is I would like to use matching ID_2 to hide element. Here is my code that i have so far:

var records = [];

~[tlist_sql;
  SELECT ID_1, ID_2 
  FROM SLOTS
  ]
 records.push("~(ID_1)","~(ID_2)");
[/tlist_sql]

for(var i=0; i< records.length; i++){
    //if ID_2 is greater than 0 
    if(records[i].idTwo > 0){
        var test = ('#row_' + records[i].idOne).val();  
                alert(test)
        //here I want to use ID_1 to hide row 
        $j('#row_' + records[i].idOne).parent('.hideElement').hide();
        $j('#button1').hide();
    }       
}

Here is how my array records looks like:

[-1,2050,-1,2046,15,2048,0,2044,10,2051,0,2047]

So as you can see in this array only two records will pass if statement where ID_1 is 15,10 and ID_2 is 2048,2051. My current code doesn't use correct values looks like id's are split some how. Does anyone know how I should look for ID_1 and then for ID_2 and is array the best to use in this case? Thank you.

I want my array to look how it is but my problem is how to loop and get ID_2 inside of my if statement. — espresso_coffee
– espresso_coffee, Commented Feb 25, 2016 at 19:39
So in the array you've posted, we are looking at [ID_1, ID_2, ID_1, ID_2]? — millerbr
– millerbr, Commented Feb 25, 2016 at 19:40
That is special code that powerschool use to output values from the query. — espresso_coffee
– espresso_coffee, Commented Feb 25, 2016 at 19:51

Matt Elliott · Accepted Answer · 2016-02-25 19:43:43Z

2

Something like this perhaps:

var records = [];

~[tlist_sql;
SELECT ID_1, ID_2 
FROM SLOTS
]

records.push({
   'idOne' : "~(ID_1)",
   'idTwo' : "~(ID_2)"
});
[/tlist_sql]

Then when accessing these records:

for(var i=0; i< records.length; i++){
    //if ID_1 is greater than 0 
    if(records[i].idOne > 0){
        //here I want to use ID_2 to hide row that has matching ID
        $j('#row_' + records[i].idTwo).parent('.hideElement').hide();
        $j('#button1').hide();
    }       
}

answered Feb 25, 2016 at 19:43

Matt Elliott

1671 bronze badge

Sign up to request clarification or add additional context in comments.

8 Comments

Nielsvh Over a year ago

Shoot! You got to it first. I do like encapsulating related data in objects.

espresso_coffee Over a year ago

I do not why but this line of the code: $j('#row_' + records[i].idTwo) if I try to do .val() and alert gives me values 'on','on'. Do you know what can cause that output?

Matt Elliott Over a year ago

Could you update your main question with the code you have now where you are doing an alert on the value. As well the HTML of #row would be helpful just to get a better idea of what you mean.

espresso_coffee Over a year ago

I did update my question. Line of code where I use JQuery selector to get row_ID and hide parent does not work. I'm not sure if something is wrong with my JQuery or values that I'm passing in.

Matt Elliott Over a year ago

In your updated code you have idOne where idTwo should be and vice versa. According to your description you wanted to check if idOne was > 0 and then use idTwo to match and hide an element. Not sure if that solves your issue though.

|

Nielsvh · Accepted Answer · 2016-02-29 17:09:35Z

1

Create an object:

var records = [];

~[tlist_sql;
  SELECT ID_1, ID_2 
  FROM SLOTS
  ]
 records.push({id1:":~(ID_1)",id2:"~(ID_2)"});
[/tlist_sql]

for(var i=0; i< records.length; i++){
    //if ID_1 is greater than 0 
    if(records[i].id1 > 0){
        //here I want to use ID_2 to hide row that has matching ID
        $j('#row_' + records[i].id2).parent('.hideElement').hide();
        $j('#button1').hide();
    }       
}

https://jsfiddle.net/78s3uL95/

edited Feb 29, 2016 at 17:09

answered Feb 25, 2016 at 19:53

Nielsvh

1,2591 gold badge20 silver badges34 bronze badges

Collectives™ on Stack Overflow

How to create array in Javascript?

2 Answers 2

8 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related