ACF2021 - query result offset is not supported

Description

Looks like cf2021 hibernate dropped support for offset. I get the following error when passing offset in teh options.

Type: java.lang.UnsupportedOperationException
Messages: query result offset is not supported
Tag Context:
Tag: CF_CFPAGE
Template: D:\Projects\lawhelp.org\modules\cborm\models\BaseORMService.cfc
Line: 215
Tag: CF_SUPERSCOPE
Template: D:\Projects\lawhelp.org\modules\cborm\models\VirtualEntityService.cfc
Line: 88

I'm searching for a workaround, but thought I'd bring this to your attention. Thanks.

Activity

Show:

Luis MajanoApril 23, 2021 at 12:31 PM

Totally agree with you. Can you file a big report with them. I’ll follow up with them.

 

Also can you post the solution here so other folks can benefit?

Don BellamyApril 23, 2021 at 3:30 AM

Yup discovered that, would be nice if Adobe updated their docs. Thanks.

Luis MajanoApril 22, 2021 at 9:56 PM

If you are on Microsoft SQL then you need the right dialetc.

Don BellamyApril 22, 2021 at 8:09 PM

May just be dialect related and not completely unsupported, still looking into it.

Known Error
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Priority

Sentry

Created April 21, 2021 at 7:43 PM
Updated December 15, 2021 at 8:46 PM
Resolved December 15, 2021 at 8:46 PM