recordSet.filter

programming flash
1

Hi, I’m working on a CMS with amfphp and have a problem filtering/matching data from two recordSets. I have one photosReturn recordSet that holds data about photo gallery - title, description, id, etc… The second recordSet, allfilesReturn, contains the image information for the galleries - filepath, caption, module id, etc…

The id field from photosReturn matches the moduleid from allFilesReturn so this is the common element to match the two.

This is what I currently have in my class, but it only returns one photo instead of all of the photos within a gallery:

ActionScript Code:
[FONT=Courier New][LEFT][COLOR=#000000]**function**[/COLOR] buildPhotos[COLOR=#000000]([/COLOR][COLOR=#000000])[/COLOR] 
[COLOR=#000000]{[/COLOR] 
   [COLOR=#0000FF]for[/COLOR] [COLOR=#000000]([/COLOR][COLOR=#000000]**var**[/COLOR] i = [COLOR=#000080]0[/COLOR]; i < [COLOR=#0000FF]this[/COLOR].[COLOR=#000080]photosReturn[/COLOR].[COLOR=#0000FF]length[/COLOR]; i++[COLOR=#000000])[/COLOR] 
   [COLOR=#000000]{[/COLOR] 
      [COLOR=#000000]**var**[/COLOR] filtered_rs:RecordSet = [COLOR=#0000FF]this[/COLOR].[COLOR=#000080]calcRecords[/COLOR][COLOR=#000000]([/COLOR][COLOR=#FF0000]"allfilesReturn"[/COLOR], [COLOR=#0000FF]this[/COLOR].[COLOR=#000080]photosReturn[/COLOR].[COLOR=#000080]getItemAt[/COLOR][COLOR=#000000]([/COLOR]i[COLOR=#000000])[/COLOR].[COLOR=#000080]id[/COLOR][COLOR=#000000])[/COLOR]; 

   [COLOR=#000000]}[/COLOR] 
[COLOR=#000000]}[/COLOR]

[COLOR=#000000]function[/COLOR] calcRecords[COLOR=#000000]([/COLOR]record, id[COLOR=#000000])[/COLOR]
[COLOR=#000000]{[/COLOR]
[COLOR=#000000]function[/COLOR] sortID[COLOR=#000000]([/COLOR]aRecord, article_id[COLOR=#000000])[/COLOR]
[COLOR=#000000]{[/COLOR]
[COLOR=#0000FF]return[/COLOR] [COLOR=#000000]([/COLOR]aRecord.[COLOR=#000080]moduleid[/COLOR] == article_id[COLOR=#000000])[/COLOR];
[COLOR=#000000]}[/COLOR]
[COLOR=#0000FF]return[/COLOR] [COLOR=#0000FF]this[/COLOR][COLOR=#000000][[/COLOR]record[COLOR=#000000]][/COLOR].[COLOR=#000080]filter[/COLOR][COLOR=#000000]([/COLOR]sortID, id[COLOR=#000000])[/COLOR];
[COLOR=#000000]}[/COLOR]
[/LEFT]
[/FONT]

This is the photosReturn recordSet:

ActionScript Code:
[FONT=Courier New][LEFT]Result [COLOR=#000000]([/COLOR][COLOR=#0000FF]object[/COLOR] [COLOR=#808080]*#2) *[/COLOR]

…[COLOR=#000080]mRecordsAvailable[/COLOR]: [COLOR=#000080]2[/COLOR]
…[COLOR=#000080]serverInfo[/COLOR]: COLOR=#000000[/COLOR]
…[COLOR=#000080]uniqueID[/COLOR]: [COLOR=#000080]2[/COLOR]
…_items [COLOR=#000000]([/COLOR][COLOR=#0000FF]object[/COLOR] [COLOR=#808080]*#3) [/COLOR]
…[COLOR=#000000][[/COLOR][COLOR=#000080]0[/COLOR][COLOR=#000000]][/COLOR] [COLOR=#000000]([/COLOR][COLOR=#0000FF]object[/COLOR] [COLOR=#808080]#4) [/COLOR]
…ID: [COLOR=#000080]0[/COLOR]
…[COLOR=#000080]active[/COLOR]: [COLOR=#000080]1[/COLOR]
…[COLOR=#000080]category[/COLOR]: [COLOR=#FF0000]“Show”[/COLOR]
…[COLOR=#000080]datecreated[/COLOR]: [COLOR=#FF0000]“2006-11-22 23:20:21”[/COLOR]
…[COLOR=#000080]description[/COLOR]: [COLOR=#FF0000]“This is the first one.”[/COLOR]
…[COLOR=#000080]id[/COLOR]: [COLOR=#000080]9[/COLOR]
…[COLOR=#000080]section[/COLOR]: [COLOR=#FF0000]""[/COLOR]
…[COLOR=#000080]sectionid[/COLOR]: [COLOR=#000080]0[/COLOR]
…[COLOR=#000080]title[/COLOR]: [COLOR=#FF0000]“Collection One”[/COLOR]
…[COLOR=#000000][[/COLOR][COLOR=#000080]1[/COLOR][COLOR=#000000]][/COLOR] [COLOR=#000000]([/COLOR][COLOR=#0000FF]object[/COLOR] [COLOR=#808080]#5) [/COLOR]
…ID: [COLOR=#000080]1[/COLOR]
…[COLOR=#000080]active[/COLOR]: [COLOR=#000080]1[/COLOR]
…[COLOR=#000080]category[/COLOR]: [COLOR=#FF0000]“Press”[/COLOR]
…[COLOR=#000080]datecreated[/COLOR]: [COLOR=#FF0000]“2006-11-22 23:20:52”[/COLOR]
…[COLOR=#000080]description[/COLOR]: [COLOR=#FF0000]“This is the second one.”[/COLOR]
…[COLOR=#000080]id[/COLOR]: [COLOR=#000080]10[/COLOR]
…[COLOR=#000080]section[/COLOR]: [COLOR=#FF0000]""[/COLOR]
…[COLOR=#000080]sectionid[/COLOR]: [COLOR=#000080]0[/COLOR]
…[COLOR=#000080]title[/COLOR]: [COLOR=#FF0000]“Collection Two”[/COLOR]
…[COLOR=#000080]mTitles[/COLOR] [COLOR=#000000]([/COLOR][COLOR=#0000FF]object[/COLOR] [COLOR=#808080]#6) *[/COLOR]
…[COLOR=#000000][[/COLOR][COLOR=#000080]0[/COLOR][COLOR=#000000]][/COLOR]: [COLOR=#FF0000]“id”[/COLOR]
…[COLOR=#000000][[/COLOR][COLOR=#000080]1[/COLOR][COLOR=#000000]][/COLOR]: [COLOR=#FF0000]“section”[/COLOR]
…[COLOR=#000000][[/COLOR][COLOR=#000080]2[/COLOR][COLOR=#000000]][/COLOR]: [COLOR=#FF0000]“sectionid”[/COLOR]
…[COLOR=#000000][[/COLOR][COLOR=#000080]3[/COLOR][COLOR=#000000]][/COLOR]: [COLOR=#FF0000]“category”[/COLOR]
…[COLOR=#000000][[/COLOR][COLOR=#000080]4[/COLOR][COLOR=#000000]][/COLOR]: [COLOR=#FF0000]“title”[/COLOR]
…[COLOR=#000000][[/COLOR][COLOR=#000080]5[/COLOR][COLOR=#000000]][/COLOR]: [COLOR=#FF0000]“description”[/COLOR]
…[COLOR=#000000][[/COLOR][COLOR=#000080]6[/COLOR][COLOR=#000000]][/COLOR]: [COLOR=#FF0000]“active”[/COLOR]
…[COLOR=#000000][[/COLOR][COLOR=#000080]7[/COLOR][COLOR=#000000]][/COLOR]: [COLOR=#FF0000]“datecreated”[/COLOR]
[/LEFT]
[/FONT]

This is the allFilesReturn recordSet:

ActionScript Code:
[FONT=Courier New][LEFT]Result [COLOR=#000000]([/COLOR][COLOR=#0000FF]object[/COLOR] [COLOR=#808080]*#2) *[/COLOR]

…[COLOR=#000080]mRecordsAvailable[/COLOR]: [COLOR=#000080]3[/COLOR]
…[COLOR=#000080]serverInfo[/COLOR]: COLOR=#000000[/COLOR]
…[COLOR=#000080]uniqueID[/COLOR]: [COLOR=#000080]3[/COLOR]
…_items [COLOR=#000000]([/COLOR][COLOR=#0000FF]object[/COLOR] [COLOR=#808080]*#3) [/COLOR]
…[COLOR=#000000][[/COLOR][COLOR=#000080]0[/COLOR][COLOR=#000000]][/COLOR] [COLOR=#000000]([/COLOR][COLOR=#0000FF]object[/COLOR] [COLOR=#808080]#4) [/COLOR]
…ID: [COLOR=#000080]0[/COLOR]
…[COLOR=#0000FF]caption[/COLOR]: [COLOR=#FF0000]""[/COLOR]
…[COLOR=#000080]cmspath[/COLOR]: [COLOR=#FF0000]“userimages/9daily_tn.jpg”[/COLOR]
…[COLOR=#000080]datecreated[/COLOR]: [COLOR=#FF0000]“2006-11-26 21:11:47”[/COLOR]
…[COLOR=#000080]filepath[/COLOR]: [COLOR=#FF0000]"/cms/photos/userimages/9daily_tn.jpg"[/COLOR]
…[COLOR=#000080]id[/COLOR]: [COLOR=#000080]150[/COLOR]
…[COLOR=#000080]module[/COLOR]: [COLOR=#FF0000]“photos”[/COLOR]
…[COLOR=#000080]moduleid[/COLOR]: [COLOR=#000080]9[/COLOR]
…[COLOR=#000080]section[/COLOR]: [COLOR=#FF0000]""[/COLOR]
…[COLOR=#000080]sectionid[/COLOR]: [COLOR=#000080]0[/COLOR]
…[COLOR=#000000][[/COLOR][COLOR=#000080]1[/COLOR][COLOR=#000000]][/COLOR] [COLOR=#000000]([/COLOR][COLOR=#0000FF]object[/COLOR] [COLOR=#808080]#5) [/COLOR]
…ID: [COLOR=#000080]1[/COLOR]
…[COLOR=#0000FF]caption[/COLOR]: [COLOR=#FF0000]""[/COLOR]
…[COLOR=#000080]cmspath[/COLOR]: [COLOR=#FF0000]“userimages/10item_tn.jpg”[/COLOR]
…[COLOR=#000080]datecreated[/COLOR]: [COLOR=#FF0000]“2006-11-26 21:11:31”[/COLOR]
…[COLOR=#000080]filepath[/COLOR]: [COLOR=#FF0000]"/cms/photos/userimages/10item_tn.jpg"[/COLOR]
…[COLOR=#000080]id[/COLOR]: [COLOR=#000080]149[/COLOR]
…[COLOR=#000080]module[/COLOR]: [COLOR=#FF0000]“photos”[/COLOR]
…[COLOR=#000080]moduleid[/COLOR]: [COLOR=#000080]10[/COLOR]
…[COLOR=#000080]section[/COLOR]: [COLOR=#FF0000]""[/COLOR]
…[COLOR=#000080]sectionid[/COLOR]: [COLOR=#000080]0[/COLOR]
…[COLOR=#000000][[/COLOR][COLOR=#000080]2[/COLOR][COLOR=#000000]][/COLOR] [COLOR=#000000]([/COLOR][COLOR=#0000FF]object[/COLOR] [COLOR=#808080]#6) [/COLOR]
…ID: [COLOR=#000080]2[/COLOR]
…[COLOR=#0000FF]caption[/COLOR]: [COLOR=#FF0000]""[/COLOR]
…[COLOR=#000080]cmspath[/COLOR]: [COLOR=#FF0000]“userimages/9angeleno_tn.jpg”[/COLOR]
…[COLOR=#000080]datecreated[/COLOR]: [COLOR=#FF0000]“2006-11-26 21:19:44”[/COLOR]
…[COLOR=#000080]filepath[/COLOR]: [COLOR=#FF0000]"/cms/photos/userimages/9angeleno_tn.jpg"[/COLOR]
…[COLOR=#000080]id[/COLOR]: [COLOR=#000080]151[/COLOR]
…[COLOR=#000080]module[/COLOR]: [COLOR=#FF0000]“photos”[/COLOR]
…[COLOR=#000080]moduleid[/COLOR]: [COLOR=#000080]9[/COLOR]
…[COLOR=#000080]section[/COLOR]: [COLOR=#FF0000]""[/COLOR]
…[COLOR=#000080]sectionid[/COLOR]: [COLOR=#000080]0[/COLOR]
…[COLOR=#000080]mTitles[/COLOR] [COLOR=#000000]([/COLOR][COLOR=#0000FF]object[/COLOR] [COLOR=#808080]#7) *[/COLOR]
…[COLOR=#000000][[/COLOR][COLOR=#000080]0[/COLOR][COLOR=#000000]][/COLOR]: [COLOR=#FF0000]“id”[/COLOR]
…[COLOR=#000000][[/COLOR][COLOR=#000080]1[/COLOR][COLOR=#000000]][/COLOR]: [COLOR=#FF0000]“caption”[/COLOR]
…[COLOR=#000000][[/COLOR][COLOR=#000080]2[/COLOR][COLOR=#000000]][/COLOR]: [COLOR=#FF0000]“section”[/COLOR]
…[COLOR=#000000][[/COLOR][COLOR=#000080]3[/COLOR][COLOR=#000000]][/COLOR]: [COLOR=#FF0000]“sectionid”[/COLOR]
…[COLOR=#000000][[/COLOR][COLOR=#000080]4[/COLOR][COLOR=#000000]][/COLOR]: [COLOR=#FF0000]“module”[/COLOR]
…[COLOR=#000000][[/COLOR][COLOR=#000080]5[/COLOR][COLOR=#000000]][/COLOR]: [COLOR=#FF0000]“moduleid”[/COLOR]
…[COLOR=#000000][[/COLOR][COLOR=#000080]6[/COLOR][COLOR=#000000]][/COLOR]: [COLOR=#FF0000]“filepath”[/COLOR]
…[COLOR=#000000][[/COLOR][COLOR=#000080]7[/COLOR][COLOR=#000000]][/COLOR]: [COLOR=#FF0000]“cmspath”[/COLOR]
…[COLOR=#000000][[/COLOR][COLOR=#000080]8[/COLOR][COLOR=#000000]][/COLOR]: [COLOR=#FF0000]“datecreated”[/COLOR]
[/LEFT]
[/FONT]

Thanks for any help!