Help w/ Comparing Two Multidimensional Arrays

Hi guys, I have been stumped for a few days and have googled the heck out of my problem and have given up and need help.
 
I'm trying to populate a combobox by comparing two multidimensional arrays that have different subscript ranges.
 
My first array has all sizes in a table
ex: array1 [
{"InventorySizeId": 1, "InventorySizeName": "small"},
{"InventorySizeId": 2, "InventorySizeName": "medium"},
{"InventorySizeId": 3, "InventorySizeName": "large"}
]
 
My second array has only the sizes within a certain item
ex: array2 [
{"InventorySizeId": 1, "InventorySizeName": "medium"},
{"InventorySizeId": 2, "InventorySizeName": "large"}
]
 
I need help looping through both arrays, comparing, and displaying the items in array1 that dont match array2.
 
pseudocode:
for i=0 To Ubound(array1, 2)
for s=0 To Ubound(array2, 2)
       if i <> s then
           call function that creates a json object
       exit for
     end if
    next
next
 
I think I'm really close, but I don't know. Any help would be appreciated. Thanks!

So just to be clear, you want to do this in VBScript?

Yes I think everything is good except for my if statement. How do I check the items of each array statement?

first I have a couple of questions:
 
What consitutes a match? Do both parts have to be the same (ID and Name)? Or would the same name existing in each array with different IDs still count as matching?
 
Do you control the way these arrays are built? If you do then I suspect that a dictionary would not only make the comparison easier, it would make the data easier to work with.

I'm grabbing these recordsets from sql and all sizes have a unique id so really I can just compare the first part, second or whole it doesn't really matter because no value will have the same id or name.

So do you have an array or a recordset? Which one? Also, if you are executing a query to generate the data, why not get the correct list with the query? SQL is much better at this than an algorithm that you write after the fact would be.

I am making two database hits with two seperate function calls and returning 2 recordsets as 2 seperate arrays.
 
I have an associate table( tblSizeChart ) that is connected with a 2 foreign keys to 2 seperate look up tables, which is lutItem and lutSize.
 
So the first array has a recordset( select sizeId, sizeName from lutSize ) and the second array has ( select sizeId, sizeName from tblSizeChart where itemId = ? )
 
I'm trying to populate a combobox with only the sizes that aren't already being associated with a certain item.
 
I hope this helps. Would there be some kind of sql statement that would be faster to get this information, instead of looping through two arrays?

Yes, doing it in SQL would be a much preferable solution in my opinion. Something like:
 
SELECT lutSize.sizeID, lutSize.sizeName FROM lutSize WHERE NOT EXIST (SELECT tblSizeChart.sizeID FROM tblSizeChart WHERE lutSize.sizeID = tblSizeChart.sizeID)
 
I'm not a huge SQL person, but something along those lines should do what you want.

Ok ya I think that would be a lot easier. I'm going to work with my query and see if I can pull the information that I need.

Ok I got the fix!!! SQL it is!
 
select distinct sl.sizeId, sizeName from lutSize as ls
where ( select count( st.sizeId ) from tblSizeChart as st
where st.itemId = ? and sl.sizeId = st.sizeId ) = 0
 
The (?) is the itemId that I pass in. THANKS ebgreen for all your help!!!

Glad you worked it out. It's an odd day when I answer something in the ASP section. Even odder if I get anywhere near to the right answer.