[FX.php List] AddSortParam line shows 0 records

[Denis Somar]

I tried all that you mention before posting to the group, I think, and
still no avail:

• Is the SORT FIELD on the layout called? == The sort field is definitely
on the layout, is that what you mean?  It is used in my work loop later in
the file
• Is the name the same as a "custom sort by value list"? == No value lists
in the DB
• Does the sort field have a value list assigned to it? == Nope

I did try it with the sort field right before FMFind line and it worked
just the same.  Drats......





On Wed, Jan 11, 2012 at 11:14 PM, BEVERLY VOTH <beverlyvoth at gmail.com>wrote:

> I always put the sort after the query fields, but I don't know if that
> makes a difference.
>
> Is the SORT FIELD on the layout called? Is the name the same as a "custom
> sort by value list"? Does the sort field have a value list assigned to it?
> Again, I don't know if that makes a difference, but these are the things I
> look for when debugging.
>
> And lastly, did you try assigning the sort order of "Ascend, Descend, or
> Custom"? I found out the hard way that this should not be quoted.
>
> Beverly
>
> On 11 Jan 2012, at 10:50 PM, Denis Somar wrote:
>
> > Hi all,
> >
> > I have a simple issue/question on OS X.7, running FM11SA.  I have a
> query which works perfectly BUT when I add a line with AddSortParam, the
> code suddenly returns 0 records.  I've tried retyping it and can't think
> what the issue might be - any ideas or experiences with this?
> >
> > Here's the code for arg's sake:
> > $q->SetDBUserPass( $webUN, $webPW );
> > $q->SetDBData( $webDB, 'Quotes_Lines_layout' );
> > $q->AddSortParam('quote_id');         //<<<<<<<<<<<<<<<<<<<<< THIS IS
> THE LINE THAT BORKS EVERYTHING
> > $q->AddDBParam( 'Quotes_lines to quotes::user_id',
> $_SESSION[$pKey]['id'] );
> > $q->AddDBParam( 'quote_id', $_GET["id"] );
> > $r = $q->FMFind();
> >
> > As always, thanks in advance.
> >
> > Denis
> > _______________________________________________
> > 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20120111/49596319/attachment-0001.html