I can't thanks you enough for your excellent help - but I'll try...
THANK YOU - THANK YOU - THANK YOU !
On Jan 29, 2015, at 5:57 PM, Christoph Becker <cmbecker69@xxxxxx> wrote:
> dealTek wrote:
>
>> Q: I think when I tried to sort on numeric field is came back as text
>> type sort...
>>
>> Is there a way to designate a numeric sort on certain fields?
>
> Yes, of course. An example is given on the manual page[1]. However, I
> consider that somewhat clumsy. Instead you could do:
>
> function cmp($a, $b)
> {
> return $a - $b;
> }
>
> I suggest to mentally walk through some examples (e.g. cmp(3, 4); cmp(4,
> 3); cmp(3,3)) to better understand what's happening.
>
>> Q: Is it also possible to sort a more than 1 field like sort on
>> Contact_Last & also State field at same time?
>
> Yes, for instance:
>
> function cmp($a, $b)
> {
> $result = strcmp(
> $a->getField('Contact_Last'),
> $b->getField('Contact_Last')
> );
> // indifferent, i.e. last names are identical, so sort by state
> if (!$result) {
> $result = strcmp(
> $a->getField('State'),
> $b->getField('State')
> );
> }
> return $result;
> }
>
> Probably you want to exchange the conditions (i.e. sort by state first,
> then sort by last name), but that depends on your use-case.
>
> Note, that strcmp() is case sensitive, and that there is strcasecmp()
> which is case insensitive. Also note, that both depend on the current
> locale AFAIK, and that it might be necessary to use the Collator class[2].
>
> Sorting can get very tricky... :(
>
> [1] <http://php.net/manual/en/function.usort.php>
> [2] <http://php.net/manual/en/class.collator.php>
>
> --
> Christoph M. Becker
--
Thanks,
Dave - DealTek
dealtek@xxxxxxxxx
[db-15]
