Question
Sébastien Demoustiez · Oct 10, 2016

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

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

 

 

0
0 436
Discussion (2)0
Log in or sign up to continue

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.

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 :)