help with dtc grid 1

[bryant89]

my dtc recordset will not display properly if there is a dtc grid on the same page. I have a loop that goes through the dtc recordset retrieve all records but for some reason it will only work properly if there is no dtc grid present on the same page. I need to have both working. Can anyone help me.

Bryant

 

[palbano]

Bryant,

I really can't tell what you are doing from your discription. Here is a tip for using DTC recordsets and grids anyway.

When the page loads in the Script Engine the Recordset is loaded and the cursor is at the first row. The grid moves through the recordset row by row to populate the grid. If you have code that runs before the grid is populated that modifies the position of the recordset cursor you need to perform a MoveFirst() on the recordset when you complete your operation so the grid can reuse the recordset to populate the grid.

Good luck
-pete

 

[bryant89]

Sorry about the bad explanation.

I have 2 different recordsets
One I output using a grid
The other I output manually using a table and a do while loop.

So what I did was use .moveFirst() for the manual one and it works great now. Thank you very much Pete. I am sorry for bad explanations but they will get better I promise.

Thanks for your patience.

Bryant