When I do a SELECT i afterwards use the date with rs("field")

But when I want to us it in a "DO WHILE NOT rs.EOF" it seem to loose sometime the data(???)

there are some fields which I can´t retrieve. When I put in front of the "DO WHILE NOT rs.EOF", RESPONSE.WRITE rs("FIELDX") it shows on the screen, if I put it in the "DO WHILE NOT rs.EOF" it doesn´t exists....

Anybody knows what it could be???

Cheers and thx,
David

Ok, I found the solutions.

I used "SELECT * FROM CLIENTS WHERE[CONDITIONS]", which gave me zero results.
But if I uses" SELECT name,adress,.... FROM CLIENTS WHERE[CONDITIONS]" if gives me results when I use "rs("field")

Anybody knows why this is? The table has a lot of fields, so is it posible that SQl server only can return an amount of fields?

regards,

David