|
|
problems when using a datareader with SLX
Posted: 05 Dec 07 5:54 PM
|
sO I was trying to implement pagination with SLX and noticed that for some reason everytime I changed pages the data wouldn't change...until I got to like page 6 or 7.. Well I was really confused so I went through a SQL Provider instead and it worked FINE.. Finally I boiled the problem down to:
1) you have to read data from the data reader in order for it to move on
so just doing for() reader.Read()
Won't move on to the next record you have to read a piece of data from the reader
for() { Response.Write(reader["data"]); reader.Reader() };
does work
2)
or if you iterate across it like 50 times it causes it to finally move
That's why pages 1 through 5 would show the same data but 6 and on would finally change
is that just what I have to do? Or is there a setting missing?
shane |
|
|
|
Re: problems when using a datareader with SLX
Posted: 06 Dec 07 10:09 AM
|
| What version of SLX is this? This will likely work in v7.2 as I was told that changes were made to the provider to better support pagination from the SLX web client as well. |
|
|
| |
| |
| |
|
Re: problems when using a datareader with SLX
Posted: 07 Dec 07 9:52 PM
|
Originally posted by Shane
"Not Documented"
i've found that to be a big problem in general
and upgrading stuff to 7.2 fixed the pagination problem
yay |
|
Documentation. That's always been a problem with SLX. Glad to hear that the upgrade to 7.2 fixed the problem.
-Ryan |
|
|
|