[FX.php List] Re-AddSortParam line shows 0 records

[Denis Somar]

I did try other fields and get the same result.

The URL is as it should be:
http://localhost/bzb/reviewquote.php?id=1

Thanks!
Denis



On Wed, Jan 11, 2012 at 11:39 PM, Masayuki Nii <msyk at msyk.net> wrote:

> Although his is not the complete resolver, try to set other fields than
> "quote_
> id" to AddSortParam's first parameter, ex. "Quotes_lines to
> quotes::user_id"
> or others. It can be a hint of what is the problem.
>
> The error code was 5, and how was URL field of the result?
>
> Denis Somar <dsomar at gmail.com> さんが、2012/1/12 13:26:12に送られた
> ---“Re: [FX.php List] AddSortParam line shows 0 records”によりますと
> > 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
> > >
> >
> >
>
> _______________________________________________________________
> Masayuki Nii/Masayuki Nii <msyk at msyk.net> <msyk at mac.com>:iChat Ready
> Web Site <http://msyk.net> / INTER-Mediator [for Web App]
> http://msyk.net/im
> Twitter: @msyknii (Japanese), @MasayukiNii (English) / Facebook: Masayuki
> Nii
>
> _______________________________________________
> 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/0eb229c5/attachment.html