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

[Jonathan Schwartz]

Huh?


>;-) 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
>>
>_______________________________________________
>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