# recordSet.filter

**URL:** <https://forum.kirupa.com/t/recordset-filter/208325>\
**Category:** flash\
**Created:** [November 27, 2006, 5:17pm UTC](https://forum.kirupa.com/t/recordset-filter/208325 "2006-11-27T17:17:42Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![horizens](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/horizens/32/2714_2.png) [@horizens](https://forum.kirupa.com/u/horizens)\
**Post date:** [November 27, 2006, 5:17pm UTC](https://forum.kirupa.com/t/recordset-filter/208325/1 "2006-11-27T17:17:42Z")

</div>

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 &lt; [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!