[FX.php List] Getting a set of unique records

Gjermund Gusland Thorsen ggt667 at gmail.com
Wed Aug 20 09:21:22 MDT 2008


;-) cat values.txt | sort | uniq in FileMaker is called ValueList :-)

ggt

2008/8/20 Jonathan Schwartz <jschwartz at exit445.com>:
> That's it.  VALUE LIST.  Thanks guys. Sorry for the vague question.
>
> J
>
> At 10:32 AM -0400 8/20/08, Someone wrote:
>>
>> try value list on that field
>>
>> On Aug 20, 2008, at 10:28 AM, Bob Patin wrote:
>>
>>> Jonathan,
>>>
>>> Your question wasn't very clear, but if you mean that each record needs
>>> to be unique based on one of the fields, you could loop through the found
>>> set in PHP once you've retrieved it, and only display unique records. You'd
>>> want to sort your query results by that field, and then loop through,
>>> comparing the first record with the subsequent one each time through the
>>> loop.
>>>
>>> Hope this helps,
>>>
>>> Bob Patin
>>> Longterm Solutions
>>> bob at longtermsolutions.com
>>> 615-333-6858
>>> http://www.longtermsolutions.com
>>> iChat: bobpatin
>>> AIM: longterm1954
>>> FileMaker 9 Certified Developer
>>> Member of FileMaker Business Alliance and FileMaker TechNet
>>> --------------------------
>>> FileMaker hosting and consulting for all versions of FileMaker
>>> PHP * Full email services * Free DNS hosting * Colocation * Consulting
>>>
>>> On Aug 20, 2008, at 9:22 AM, Jonathan Schwartz wrote:
>>>
>>>> Hi Folks,
>>>>
>>>> Drawing a blank on this one.
>>>>
>>>> I'm querying a many-to-many match table and need to end up just a list
>>>> of unique records based on one of the fields.
>>>>
>>>> How to do?
>>>>
>>>> J
>>>> --
>>>> Jonathan Schwartz
>>>> Exit 445 Group
>>>> jonathan at exit445.com
>>>> http://www.exit445.com
>>>> 415-370-5011
>>>> _______________________________________________
>>>> FX.php_List mailing list
>>>> FX.php_List at mail.iviking.org
>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org
>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>
> --
> Jonathan Schwartz
> Exit 445 Group
> jonathan at exit445.com
> http://www.exit445.com
> 415-370-5011
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>


More information about the FX.php_List mailing list