I also see these doubled up:
(pair: (-sortfield)=(qdb_co_info_web::premium)),
(pair: (-sortorder)=(descending)),
(pair: (-sortfield)=(qdb_co_info_web::company)),
(pair: (-sortorder)=(ascending)),
(pair: (-sortfield)=(qdb_co_info_web::premium)),
(pair: (-sortorder)=(descending)),
(pair: (-sortfield)=(qdb_co_info_web::company)),
(pair: (-sortorder)=(ascending)),
And that the time difference is 22 seconds between the two date action_params.
Something along the chain is doubling up parameters. The chain
includes FileMaker, Lasso Connector for FileMaker, and Lasso's
[link_*group] tags.
To help isolate the issue, do a search then inspect the rendered
HTML for the link for Next Group. Paste that here in a reply.
The parameters should not be doubled up.
Also include your version of FileMaker server. There may have
been a bug in FM in an earlier version that has since been resolved.
--steve
On 8/13/13 at 2:27 PM, ddusharme@qualitydigest.com pronounced:
>
>I am running Lasso 8.1
>
>Originally one of my pages had this:
>
>[Inline: (action_params), -Search, -Database='buyers guides',
>-Table='web layout', -Keyfield='ID', -maxrecords=25,
>-SortField='qdb_co_info_web::premium', -SortOrder='descending',
>-SortField='qdb_co_info_web::company', -SortOrder='ascending']
>Which worked fine.
>
>In order to only search for records beyond a certain date, I changed to this:
>
>[Inline: (action_params), -Search, -Database='buyers guides',
>-Table='web layout', -operator='gt', 'qdb_co_info_web::modified
>online date'= (Date_Subtract: (Date), -Year=6), -Keyfield='ID',
>-maxrecords=25, -SortField='qdb_co_info_web::premium',
>-SortOrder='descending', -SortField='qdb_co_info_web::company', -SortOrder='ascending']
>Note the addition of: -operator='gt',
>'qdb_co_info_web::modified online date'= (Date_Subtract:
>(Date), -Year=6),
>This also works fine. No problem.
>
>
>Here is the problem: If I do search where, for instance, the "Company" field = "d"
>I get the records I expect, about 150 of them, of which the first 25 show.
>However, when I click on the Next Records link, i.e. [Link_NextGroup]
>No records are shown.
>
>This used to work before the above change.
>
>If I take the date checking out of the Inline search,
>everything goes back to normal and works fine.
>
>So to troubleshoot I added [action_params] to the page.
>
>
>When I first land on the page I see this:
>
>array: (pair: (-search)=()), (pair: (-database)=(buyers
>guides)), (pair: (-table)=(web layout)), (pair:
>(-keyfield)=(ID)), (pair: (-keyvalue)=()), (pair:
>(-operatorlogical)=(and)), (pair: (-maxrecords)=(25)), (pair:
>(-skiprecords)=(0)), (pair:
>(-sortfield)=(qdb_co_info_web::premium)), (pair:
>(-sortorder)=(descending)), (pair:
>(-sortfield)=(qdb_co_info_web::company)), (pair:
>(-sortorder)=(ascending)), (pair: (-op)=(bw)), (pair:
>(qdb_co_info_web::Company)=(d)), (pair: (-op)=(bw)), (pair:
>(alldesc)=()), (pair: (-op)=(bw)), (pair:
>(qdb_co_info_web::state)=()), (pair: (-op)=(bw)), (pair:
>(bgcatdesc)=()), (pair: (-op)=(bw)), (pair: (-find)=(Start
>Search)), (pair: (-op)=(gt)), (pair: (qdb_co_info_web::modified
>online date)=(08/12/2007 15:48:55))
>
>After I click the Next Records link I see this:
>
>array: (pair: (-search)=()), (pair: (-database)=(buyers
>guides)), (pair: (-table)=(web layout)), (pair:
>(-keyfield)=(ID)), (pair: (-keyvalue)=()), (pair:
>(-operatorlogical)=(and)), (pair: (-maxrecords)=(25)), (pair:
>(-skiprecords)=(25)), (pair:
>(-sortfield)=(qdb_co_info_web::premium)), (pair:
>(-sortorder)=(descending)), (pair:
>(-sortfield)=(qdb_co_info_web::company)), (pair:
>(-sortorder)=(ascending)), (pair:
>(-sortfield)=(qdb_co_info_web::premium)), (pair:
>(-sortorder)=(descending)), (pair:
>(-sortfield)=(qdb_co_info_web::company)), (pair:
>(-sortorder)=(ascending)), (pair: (-op)=(bw)), (pair:
>(-find)=(Start Search)), (pair: (-op)=(bw)), (pair:
>(qdb_co_info_web::Company)=(d)), (pair: (-op)=(bw)), (pair:
>(alldesc)=()), (pair: (-op)=(bw)), (pair:
>(qdb_co_info_web::state)=()), (pair: (-op)=(bw)), (pair:
>(bgcatdesc)=()), (pair: (-op)=(gt)), (pair:
>(qdb_co_info_web::modified online date)=(08/12/2007 15:48:55)),
>(pair: (-op)=(gt)), (pair: (qdb_co_info_web::modified online
>date)=(08/12/2007 1
>5:49:17))
>Note that the "modified online" field appears twice. I think
>this is what is causing the search generated by the Next
>Records link not to work.
>
>
>Am I doing something wrong?
>
>Thanks
>
>
>
>
>#############################################################
>
>Attend the Lasso Developer Conference 2013!
>Sept 12-14, 2013 in Niagara Falls, Canada
>http://www.lassosoft.com/LDC-niagara-falls-2013
>
>#############################################################
>This message is sent to you because you are subscribed to
>the mailing list Lasso
>Lasso@lists.lassosoft.com
>To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
>Send administrative queries to <Lasso-request@lists.lassosoft.com>
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- --
Steve Piercy Web Site Builder
Soquel, CA
<web@StevePiercy.com> <http://www.StevePiercy.com/>
#############################################################
Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013
#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso
Lasso@lists.lassosoft.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>