|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
February 11th, 2003, 11:27 AM
|
|||
|
|||
|
Comparing Two Arrays
How do you compare the content of two arrays
I have one array - aLinkCat (contents: LinkID and CategoryID) and another array called aCat (contents: CategoryID) I want to determine when the value in aLinkCat (CategoryID) matches the value in aCat (CatagoryID, CategoryName), so that I can indicate that categoryid has been selected. I need to compare the second element in the first array with the first element in the second array. Thanks in advance! Last edited by aspnewbie : February 11th, 2003 at 12:00 PM.
|
|
#2
February 11th, 2003, 03:38 PM
|
|||
|
|||
|
I got it to work eventually, although it's not pretty.
Code:
set oRS = GetRS(sConn, "usp_GetLinkCategories @lid =" & iLID)
sCategorySelect = ""
while not (oRS.eof or oRS.bof)
sCategorySelect = sCategorySelect+ cstr(oRS("CategoryID")) + ","
oRS.movenext
wend
if "" & sCategorySelect <>"" then
sCategorySelect = left(sCategorySelect,len(sCategorySelect)-1)
End if
'Response.Write sCategorySelect
y= split(sCategorySelect,",")
aCat = GetArrRS(sConn,"usp_ListCategories")
sCategorySelect = "<Select name=""sCategorySelect"" multiple>"
If IsArray(aCat) then
for j = 0 to Ubound(aCat, 2)
sCategorySelect = sCategorySelect & "<option value=""" & aCat(0, j) & """"
for i = 0 to Ubound(y)
if cint(y(i))=aCat(0, j) then
sCategorySelect = sCategorySelect + " selected "
exit for
End if
Next
sCategorySelect = sCategorySelect + ">" + aCat(1, j)
sCategorySelect = sCategorySelect & "</option>"
Next
End if
sCategorySelect= sCategorySelect & "</select>"
Presumably there is a shorter way. If anybody has any better suggestions, I'm all ears!
|
|
| Viewing: Dev Articles Community Forums > Programming > ASP Development > Comparing Two Arrays |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
