Hi there

I'm using SQL server 2000 and asp and am using a SELECT statement. I'm looping through the statement and pulling out the records.

I want to pull out the same records furhter on down the page again but it's pulling out only the first record. However, it pulls out the first record and loops it the amount of times records appear in the table.

I'm almost there but not quite.

can anyone help me here?

thanks

Adam

Hi Adam,

Can you post that part of the code where you feel it goes wrong?

Cheers!

_________________________
- Vijay G
Strive for Perfection

Hi

From experience I normally set variables with the recordset fields. Also in the same order as they appear in the tables. The reason for this is that I have experienced stuff like empty recordset when u move back to a previous field even though u on the same line or only being able to access fileds with Datatypes text once! This might not be ur problem but would be worth having a look at.

Have a look at cursor types:
http://msdn.microsoft.com/library/de...dobjodbrec.asp

Regards
Marnus