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>