add function queryLazy

Description

we add this function, because <cfquery lazy="true"> does not work with MySQL because of the limitation of the MySQL JDBC implementation.
cfquery produces a query object that can be used more than once and MySQL only supports streaming with the "forward_only_cursor", what is incompatible with the query object.

the function queryLazy will need a function passed in as an argument, that then will be called by QueryLazy to pass the records. So the function will not create a query as result.

Activity

Zac Spitzer 
17 November 2023 at 15:59
(edited)

6

Zac Spitzer 
17 April 2020 at 14:58

check the commit logs since i posted that… was fixed with referencing the task in the commit

Pothys - MitrahSoft 
17 April 2020 at 14:45

Hi , I've checked as per your code. But, it works fine for me. I couldn't face any error.

Zac Spitzer 
14 April 2020 at 19:01

call this script with ?f=struct

 

lucee.runtime.exp.NativeException: java.lang.NullPointerException at lucee.runtime.type.util.StructSupport.invalidKey(StructSupport.java:65) at lucee.runtime.type.StructImpl.get(StructImpl.java:139) at lucee.runtime.functions.query.QueryLazy.exe(QueryLazy.java:229) at lucee.runtime.functions.query.QueryLazy.call(QueryLazy.java:132)

Michael Offner 
8 April 2020 at 15:16

Fixed

Details

Assignee

Reporter

Labels

New Issue warning screen

Before you create a new Issue, please post to the mailing list first https://dev.lucee.org

Once the issue has been verified, one of the Lucee team will ask you to file an issue

Fix versions

Priority

Created 8 April 2020 at 15:13
Updated 17 November 2023 at 16:13
Resolved 14 April 2020 at 14:41