dtc recordset and dtc grid will not work on the same page 1

[bryant89]

I have a dtc recordset on my page that loops through and retrieves records pertaining to a certain id. On this same page I also have a grid that retrieves different data pertaining to the same id. Anyway the problem exists after pressing the grid navigation buttons. Once a grid navigation button is pressed the dtc recordset on my page will only retrieve the first record and will not loop through and retrieve all pertaining records as it does when the page first loads. Is there any way to fix this problem?

Any suggestions will help

Thank you Bryant Moore

 

[palbano]

Bryant,

I am confused by your question,

> I have a dtc recordset on my page that loops through

A DTC Recordset will not 'loop through' anything, I am lost.

-pete

 

[bryant89]

sorry pete
This is what I mean. I have pasted my code. I loop through the recordset

dtc recordset is here ->named rcsFirmDiscipline


<% if rcsFirmDiscipline.getCount()>0 then %>

<% do while not rcsFirmDiscipline.EOF %>
<B><I><%=txtDiscipline.value%></I></B><BR>
<% rcsFirmDiscipline.moveNext %>
<% loop %>

<% end if %>

I loop through the recordset displaying as many records that exist. But for some reason it will not continue looping through after the dtcgrid nav buttons have been pressed.
I hope this makes sense

 

[palbano]

Try adding this line and see what it does

RecordCount: <%=rcsFIrmDiscipline.getCount()%>
<% if rcsFirmDiscipline.getCount()>0 then %>

-pete

 

[bryant89]

ya I have tried that just to make sure. IT is returning that there are 4 records but only the first one is returned. But all 4 records are returned when the page is first hit. Then I will hit the navigation buttons on the grid to see more of the records in the grid. The page then does a refresh to update the grid with the new records. The grid records are returned fine but the other recordset does not work properly.

I hope this makes sense.

Bryant

 

[palbano]

> I hope this makes sense.

Nope, sorry but it does not.


> but the other recordset does not work

You have only mentioned one recordset in your previous posts.

-pete