[Solved]Reset the cursor of a Query (resultset)

Question

Question

Sébastien Demoustiez · Oct 10, 2016

#Caché

Hello,

First sorry for my english :)

I'm looking for a solution to reset the cursor of a query in a csp page.

In my code I do:

<csp:query name="users" classname="UserId" queryname="Find">
<csp:while condition="users.Next()">
...
</csp:while>

And 100 lines after I have to do exactly the same ...

Is it a way to do the while without do the query again ?

Something like users.Reset() ??

Thanks a lot for your help

Sébastien

Discussion (2)0

Log in or sign up to continue

Dmitry Maslennikov · Oct 10, 2016

You can't reset query, and loop again on the same result. You should execute as many as you need their results.

But I think you can store result somehow, to some you buffer, and use it in next time.

2 0

score 0 · Answer 1 · 2016-10-10T07:47:34-04:00

Thanks for your answer.

You absolutly right.

You cant directly save the request in a variable but you can create a classmethod that execute the query and return the resultset. And then you can save this return in a variable.

Thanks a lot Dmitry that save 10s of page load :)