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

[Masayuki Nii]

Denis Somar <dsomar at gmail.com> さんが、2012/1/12 13:52:32に送られた
　　---“Re: [FX.php List] Re-AddSortParam line shows 0 records”によりますと
> 
> The URL is as it should be:
> http://localhost/bzb/reviewquote.php?id=1

Hi Denis, Above might be the access url of your page. I meant the URL is contained 
in the result from FX, as like:

$r = $q->FMFind();
$theURLWeWannaKnow = $r['URL'];
> 
> 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
> >
> 
> 

_______________________________________________________________
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<!--
OME_SendMail:NOBREAK-->差出人のアドレスはML受信専用です。私信メールは@以前を“
nii”で送付してください。